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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Completing a Chart
The table you want to start with has already been pivoted or cross-tabbed
from the original data, which is in the form you retyped the list as. Starting with the list (a flat database structure), you can easily produce the chart and using pivot tables or array formulas you can easily produce the table you began with. To convert your already cross-tabbed data into a list, select it, go to Data menu Pivot Table Report, step through the wizard selecting the defaults, and Excel will draw an empty Pivot Table frame. Drag the Year field into the Rows area, and each of the months into the Data area. You will end up with this pivot table (I've turned off row and column totals): Year Data Total 1997 Sum of Jan. 49.2 Sum of Feb. 43.5 Sum of Mar. 35.3 Sum of Apr. 25.9 1998 Sum of Jan. 33.3 Sum of Feb. 23.3 Sum of Mar. 22.2 Sum of Apr. 22.1 You could make a pivot chart from this data, or copy the data, paste special as values elsewhere, delete the cells containing 'Year' and 'Data', select the range including these empty cells, and make a regular chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mung Q" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Completing a Chart
You're awesome! Thanks!!!
-- Mung Q "Jon Peltier" wrote: The table you want to start with has already been pivoted or cross-tabbed from the original data, which is in the form you retyped the list as. Starting with the list (a flat database structure), you can easily produce the chart and using pivot tables or array formulas you can easily produce the table you began with. To convert your already cross-tabbed data into a list, select it, go to Data menu Pivot Table Report, step through the wizard selecting the defaults, and Excel will draw an empty Pivot Table frame. Drag the Year field into the Rows area, and each of the months into the Data area. You will end up with this pivot table (I've turned off row and column totals): Year Data Total 1997 Sum of Jan. 49.2 Sum of Feb. 43.5 Sum of Mar. 35.3 Sum of Apr. 25.9 1998 Sum of Jan. 33.3 Sum of Feb. 23.3 Sum of Mar. 22.2 Sum of Apr. 22.1 You could make a pivot chart from this data, or copy the data, paste special as values elsewhere, delete the cells containing 'Year' and 'Data', select the range including these empty cells, and make a regular chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mung Q" wrote in message ... 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 |
Reply |
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) |