Compare 1 yr's figures with another in a chart



How can I compare my 2005 and 2006 figures in a chart? I have 10 products,
which sales fluctuating year on year. I want to show differences between
sales ytd for 2006 compared to last year, 2005. I don't want my chart to
look too busy.

I suppose I'd like to have 10 bars, one for each product, each with a
shadow, the main bar relating to 2006 (current year) and the shadow relating
to 2005 (previous year). Can't find this anywhere.

But any other suggestion will be considered! Thanks.

Kelly O'Day


I have a how to and sample file for Day of year Trend Charts that may be
just what you need.

DOY charts can compare sales YTD for 2005 versus 2006 as you mentioned.

You have several ways to handle the fact that you have 10 products.

All on one chart or 10 stacked charts. I suspect the stacked charts option
will be easier to interpret.

I have a post of stacked XY charts that may be helpful


(e-mail address removed)

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