Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Completing a Chart
Hello, Could anyone help me with this problem. I wanted to create chart with a table that had the months across the top horizontally and the year vertical on the right. The data was a bunch of price index data. I wanted the chart to have the year and month on the bottom x-axis, the lowest numerical value and the highest numerical value on the y-axis. When I would choose chart type as Line it would ask me to select the data source. I could only get it to read the horizontal axis label as the months and not the year. How would I combine the 2? I had to retype all the data like this in order to get it to work: Jan-97 49.2 Feb-97 43.5 Mar-97 35.3 Apr-97 25.9 etc.... The data originally read as such: Year Jan. Feb. Mar. Apr. 1997 49.2 43.5 35.3 25.9 1998 33.3 23.3 22.2 22.1 1999 etc.... Any help would be appreciated. Thanks, -- Mung Q |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does anyone have a template for completing tax forms 1098, 1099? | Excel Discussion (Misc queries) | |||
Completing Formula in Vba | Excel Discussion (Misc queries) | |||
Auto Completing Fields but not changing later... | Excel Discussion (Misc queries) | |||
Need some help completing this Formula | Excel Worksheet Functions | |||
Auto Complete not completing | Excel Discussion (Misc queries) |