View Full Version : Solved: Type of Chart to Use

12-14-2008, 09:41 AM
Okay I have data like the following, this spans from 1993 to 2003 (over 10 years) and I need to create a chart which shows the total quantity of sales on a monthly basis, however due to the vast amount of data, I can't decide what chart would be best to used, I was thinking maybe a stacked column chart, but I would really appreciate some suggestions. :dunno


Bob Phillips
12-14-2008, 11:30 AM
What do you need to get frokm the chart, that will drive the type.

12-14-2008, 11:33 AM
My suggestions are:
- Using one realy long column chart to include all the data in one chart
- Using 10 column charts placed one under another (one for each year)
- Using subtotals first and then creating a chart - this will allow you to swap the data to see it from different time perspective

12-14-2008, 11:41 AM
Thanks for the replies, I think I interpreted the question incorrectly.