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.
Attachment 11124
What do you need to get frokm the chart, that will drive the type.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Thanks for the replies, I think I interpreted the question incorrectly.
Posting Permissions
Reply With Quote
