Actuals and Projections on the Same Graph

[cterjesen]

I have actual production data by MONTH from Sep 03 through Dec 04. Then I have YEARLY production projections for 2005 - 2008.

Is there a way to put this on the same graph without it looking weird. When I graph it, the projections are shown dramatically more (column graph) than the actuals because it is YEARLY data versus MONTHLY actuals.

Is there a way to do a column graph on two axes with one set of data so that Sep 03 through Dec 04 is on one axis and 2005 - 2008 is on the other?

 

[jdee]

Is your data something like below: If this is what you mean, you can have your data on the same chart, two axes. One for the actuals by month, then the other for the projections - yearly. The yearly projections can be either a line or a bar, your preference. The steps I took were these using the layout below:

Using office 2000.
Highlight your data, Choose Chart Wizard, choose column, (don't worry how it looks here, will change later). Choose next, rows, next, add your titles, etc., choose finish.

Now, right click on the yearly data on the chart, choose format data series, choose axes tab, choose the radio button - secondary axis, choose ok.
You can then change from a column to a line-your preference.

As you can see I did not put in each month you were asking, but this should get you started.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		Sep-03	Oct-03	Nov-03	Dec-03	Jan-04	Feb-04	2005	2006	2007	2008
2	Mo.Actuals	2400	2500	1700	2800	2000	3800
3	Yr.Projected							48000	47000	50000	61000
Sheet1

 

[cterjesen]

This worked perfectly. Thanks!

 

[jdee]

You are very welcome, glad I could be of help. J.Dee