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

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 Solutions
http://PeltierTech.com
_______


wrote in message
ups.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

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

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

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 Solutions
http://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

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

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

u must record new one macro using the 2 axes graph that can be changed depending on your selection of currentpage. u can also use a combobox form and a new sheet containing graph already. when u change to the new pivotfield item pivotchart jump into your recorded macro. (when u change to the combobox item you can get data needed for graph )

'for finding items and get it written a new temp. file
Sub Node_selection_graph()

'To determine how many BSC Nodes are available in the data
reportfile = ActiveWorkbook.Name
Workbooks.Add
temp_file = ActiveWorkbook.Name
Windows(reportfile).Activate
Dim pt As PivotTable
Set pt = ActiveChart.PivotLayout.PivotTable
For i = 1 To pt.PivotFields("BSC").PivotItems.Count
'pt.PivotFields("BSC").CurrentPage = pt.PivotFields(" BSC").PivotItems(i).Name
Nodes(i) = pt.PivotFields("BSC").PivotItems(i).Name
Windows(temp_file).Activate
Cells(i, 1) = Nodes(i)
pt.ManualUpdate = False
pt.ManualUpdate = True
Windows(reportfile).Activate
Next i


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

u must record new one macro using the 2 axes graph that can be changed depending on your selection of currentpage. u can also use a combobox form and a new sheet containing graph already. when u change to the new pivotfield item pivotchart jump into your recorded macro. (when u change to the combobox item you can get data needed for graph )

'for finding items and get it written a new temp. file
Sub Node_selection_graph()

'To determine how many BSC Nodes are available in the data
reportfile = ActiveWorkbook.Name
Workbooks.Add
temp_file = ActiveWorkbook.Name
Windows(reportfile).Activate
Dim pt As PivotTable
Set pt = ActiveChart.PivotLayout.PivotTable
For i = 1 To pt.PivotFields("BSC").PivotItems.Count
'pt.PivotFields("BSC").CurrentPage = pt.PivotFields(" BSC").PivotItems(i).Name
Nodes(i) = pt.PivotFields("BSC").PivotItems(i).Name
Windows(temp_file).Activate
Cells(i, 1) = Nodes(i)
pt.ManualUpdate = False
pt.ManualUpdate = True
Windows(reportfile).Activate
Next i


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com