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?
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?