Comparative charts

[Guest]

I want to do a simple bar chart showing sales for each day this year, with
right next to it, sales from the same day last year. How would I setup my
table to do this? I am dumping data from another source.

THANKS!
Kelli

 

[Debra Dalgleish]

Set up your data with days down column A, with the years as headings in
row 1. For example:

2004 2005
1 100 125
2 125 132

Select a cell in the table, and use the Chart Wizard to create a chart.

Jon Peltier has a Charting tutorial that may help you:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html