Line column on 2 axes - stacked columns data not stacking

[BillGilm]

Hello,

I am running Excel 2003.

I am creating a line column chart on 2 axes. Revenue is on second y-
axis; headcount on first y-axis.

Headcount is grouped into a number of categories (13). I would like
to have each of the 13 categories as a stacked column. However, when
I try and stack the 13 categories, it works only as far as the 6th
value.

Can anyone suggest a solution.

Thanks

 

[Jon Peltier]

Don't use the built-in chart type. Use all of your data to create a stacked
column chart. Select a series that you want as a line, go to Chart menu >
Chart Type, and select a line type. Repeat for any other series you need to
change to lines.

- Jon

 

[BillGilm]

Don't use the built-in chart type. Use all of your data to create a stacked
column chart. Select a series that you want as a line, go to Chart menu >
Chart Type, and select a line type. Repeat for any other series you need to
change to lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______











- Show quoted text -

Thanks Jon,

Looks like I forgot to add the words, I'm working from a Pivot Chart.

I did try starting with a stacked column then converting to a line;
but because of the differences in volumes (revenue figures in 5
figures; people in man months) I lose sight of the people. The 2 axis
solution allowed me to scale them both appropriately.

Have I missed anything?

 

[Jon Peltier]

I've added a step:

Don't use the built-in chart type. Use all of your data to create a stacked
column chart. Select a series that you want as a line, go to Chart menu >
Chart Type, and select a line type. Repeat for any other series you need to
change to lines. Double click a series you want to move to the secondary
axis, and on the Axis tab of the dialog, choose Secondary.

- Jon

 

[BillGilm]

I've added a step:

Don't use the built-in chart type. Use all of your data to create a stacked
column chart. Select a series that you want as a line, go to Chart menu >
Chart Type, and select a line type. Repeat for any other series you need to
change to lines. Double click a series you want to move to the secondary
axis, and on the Axis tab of the dialog, choose Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______










- Show quoted text -

Got it this time

Thanks

Bill