Bar chart asisstance - year to date sales

J

jmcclain

I am being asked to create a bar chart on a tab that summarizes 2007 and 2008
monthly sales data along with YTD 2009 data.

The boss wants a chart that will "change" each month as data is entered for
2009 sales and them show it in relation to the same YTD period in 2007 and
2008.

Is this possible without having to adjust the data range each month?

Any help will be appreciated.

Jon
 

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

Similar Threads

Combination bar/stacked charts 1
Table within a chart 4
Linear Regresion. Sales By Year. 1
annualize sales for remainder of year 3
Excel 2007 charts: want to avoid zero values 1
Help with year to date comparison 4
Column chart - data labels problem 4
stacked column- value axis not displaying correct values 0

Top