I am trying to insert a stacked chart.

the data is thus

jan feb march apr
planned 10

executed 6


I want the stack to represent the data withing10 that is upto 6 to be one
color and 6 to 10 on y axis another color.
unfortunately it is totalling upto 16

thanking you

afd

Hi,

A column of 16 is the expected result of a stacked column. The 10
stacked on top of the 6.

What you need is to use the clustered column chart and set the Overlap
value to 100. This will place the columns infront, rather than on top,
of each other.

Double click a column series and on the Series Options tab of the format
dialog set Overlap=100

Cheers
Andy

afdmello wrote:
I am trying to insert a stacked chart.

the data is thus

jan feb march apr
planned 10

executed 6


I want the stack to represent the data withing10 that is upto 6 to be one
color and 6 to 10 on y axis another color.
unfortunately it is totalling upto 16

thanking you

afd




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hey Andy,

Thanks a lot. I was breaking my head
one more thing. I find a lot of space to the right of my plot area. but when
I use the handle.The plot area, chart area all shrink and the month labels
also go vertical.
Is there a way to shrink only a part of the chart area.
Thanks again for this expertise

Afd
"Andy Pope" wrote in message
...
Hi,

A column of 16 is the expected result of a stacked column. The 10 stacked
on top of the 6.

What you need is to use the clustered column chart and set the Overlap
value to 100. This will place the columns infront, rather than on top, of
each other.

Double click a column series and on the Series Options tab of the format
dialog set Overlap=100

Cheers
Andy

afdmello wrote:
I am trying to insert a stacked chart.

the data is thus

jan feb march apr
planned 10

executed 6


I want the stack to represent the data withing10 that is upto 6 to be one
color and 6 to 10 on y axis another color.
unfortunately it is totalling upto 16

thanking you

afd




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

I don't understand what you mean by 'part of the chart area'.

You can move and size the plot area within the chart area.
Try unchecking AutoSize on the Font tab of the chart area.

But the layout of the axis labels is related, without much control, to
the ratio of between chart area and plot area. And sizing and layout
can/is a frustrating task with long or many labels.

Cheers
Andy


afdmello wrote:
Hey Andy,

Thanks a lot. I was breaking my head
one more thing. I find a lot of space to the right of my plot area. but when
I use the handle.The plot area, chart area all shrink and the month labels
also go vertical.
Is there a way to shrink only a part of the chart area.
Thanks again for this expertise

Afd
"Andy Pope" wrote in message
...

Hi,

A column of 16 is the expected result of a stacked column. The 10 stacked
on top of the 6.

What you need is to use the clustered column chart and set the Overlap
value to 100. This will place the columns infront, rather than on top, of
each other.

Double click a column series and on the Series Options tab of the format
dialog set Overlap=100

Cheers
Andy

afdmello wrote:

I am trying to insert a stacked chart.

the data is thus

jan feb march apr
planned 10

executed 6


I want the stack to represent the data withing10 that is upto 6 to be one
color and 6 to 10 on y axis another color.
unfortunately it is totalling upto 16

thanking you

afd




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info