On 14 Feb, 16:26, "Jon Peltier"
wrote:
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
_______

wrote in message

ups.com...



On Feb 13, 7:10 pm, "Jon Peltier"
wrote:
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
_______

wrote in message

roups.com...

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- Hide quoted text -

- 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?- Hide quoted text -

- Show quoted text -

Got it this time

Thanks

Bill