Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column charts with multiple data in each column
I have five months worth of data that contains a product and their quantity
used. I need a column chart that has the months on the x axis and the proportion of the product in each column for each month. When I try to make the chart it throws all the data for all the months into one fat column. Can anyone help?!? |
#2
|
|||
|
|||
How are your data laid out? A cross-table with products (or months) as
column headings and months (or products) as row headings? If so, a 100% stacked column chart should do the job. If you have data in a single table form, i.e., column headings are month, product, and quantity, create a PivotTable from the data with month as the row field, product as the column field and quantity as the data field. Plot this in a PivotChart (or a standard chart based on the PT). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?c3RldmUgcm9vdA==?=" <steve says... I have five months worth of data that contains a product and their quantity used. I need a column chart that has the months on the x axis and the proportion of the product in each column for each month. When I try to make the chart it throws all the data for all the months into one fat column. Can anyone help?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions |