Three items, column and line chart
 

I have data for the quarter that looks like this:
PRODUCT LINE Jan Forecast Jan Actual Jan % of Fcst
PERSONALIZED IMPACTCARDS 2,921,347 2,017,000 69%

I would like a bar chart to show (in bars) the forecast and actual, and a
secondary axes as the %. Is this possible?

I've done a chart with Forecast and % forecast, but really need the actual
bar.

TIA,

Carole O

Hi Carole -

Easier than you might think. Make a column chart using all three series
of data. Select the % series, then choose Chart Type from the Chart
menu, and select Line. Then double click on this line, and on the Axis
tab, select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Carole O wrote:

I have data for the quarter that looks like this:
PRODUCT LINE Jan Forecast Jan Actual Jan % of Fcst
PERSONALIZED IMPACTCARDS 2,921,347 2,017,000 69%

I would like a bar chart to show (in bars) the forecast and actual, and a
secondary axes as the %. Is this possible?

I've done a chart with Forecast and % forecast, but really need the actual
bar.

TIA,

Carole O

Wow! Exactly what I wanted!! Thanks, Jon

Carole O

"Jon Peltier" wrote:

Hi Carole -

Easier than you might think. Make a column chart using all three series
of data. Select the % series, then choose Chart Type from the Chart
menu, and select Line. Then double click on this line, and on the Axis
tab, select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Carole O wrote:

I have data for the quarter that looks like this:
PRODUCT LINE Jan Forecast Jan Actual Jan % of Fcst
PERSONALIZED IMPACTCARDS 2,921,347 2,017,000 69%

I would like a bar chart to show (in bars) the forecast and actual, and a
secondary axes as the %. Is this possible?

I've done a chart with Forecast and % forecast, but really need the actual
bar.

TIA,

Carole O