How to chart monthly sales for successive years



I want to show monthly figures with a line chart, with the second year coming
after the first, the third year after the second, etc. I don't want the
years to bunch up, ie 3 years-worth of bars for Jan, Feb, etc. I want
Jan-Dec 2006, then Jan-Dec 2007, and so forth. Thanks for your help!


Create a table with the dates across the top e.g. Jan-07, Feb-07, etc, then
have the monthly sales figures below the dates. Select the dates and the
sales numbers and click on insert chart.

You can see an example of this at, click on documents and
goto Excel.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question