Thread: 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
>