Increasing the Vertial Size of a 3-D Line Chart
 

Hi Everyone

I have a chart that looks good if I've only got a few items on the category
(x) axis (for days). However when I include more days the height of the chart
decreases leaving a lot of white space at the top and bottom of the chart. I
have increased the chart size but this only helps a bit.

I think what I need to do is somehow change the feature that automatically
sets the vertical scale so I can set it to manual. I realise that this will
change the relationship between the X and Y axis but this is what I want to
do.

Hope this make sense and someone can help

Thank you

Matt

Increasing the Vertial Size of a 3-D Line Chart
 

Hi,

To adjust the scale double click it and on the axis tab you can set the
min and max values.

Cheers
Andy

Matt wrote:
Hi Everyone

I have a chart that looks good if I've only got a few items on the category
(x) axis (for days). However when I include more days the height of the chart
decreases leaving a lot of white space at the top and bottom of the chart. I
have increased the chart size but this only helps a bit.

I think what I need to do is somehow change the feature that automatically
sets the vertical scale so I can set it to manual. I realise that this will
change the relationship between the X and Y axis but this is what I want to
do.

Hope this make sense and someone can help

Thank you

Matt


--

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

Increasing the Vertial Size of a 3-D Line Chart
 

Hi Andy

Sorry I obviously haven't made myself very clear here. If I increase the
scale I just get more values within the same chart area. If I descrease the
scale some of my values go off the end of the chart.

What I really want to happen is that the chart takes up a greater vertical
proportion of my plot area as the horizontal proportion has already been
maximised

Thank you

Matt


"Andy Pope" wrote:

Hi,

To adjust the scale double click it and on the axis tab you can set the
min and max values.

Cheers
Andy

Matt wrote:
Hi Everyone

I have a chart that looks good if I've only got a few items on the category
(x) axis (for days). However when I include more days the height of the chart
decreases leaving a lot of white space at the top and bottom of the chart. I
have increased the chart size but this only helps a bit.

I think what I need to do is somehow change the feature that automatically
sets the vertical scale so I can set it to manual. I realise that this will
change the relationship between the X and Y axis but this is what I want to
do.

Hope this make sense and someone can help

Thank you

Matt


--

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

Increasing the Vertial Size of a 3-D Line Chart
 

Try this, Right click the chart and pick the 3d View.
On the dialog set the Height % of base to 300.

Cheers
Andy

Matt wrote:
Hi Andy

Sorry I obviously haven't made myself very clear here. If I increase the
scale I just get more values within the same chart area. If I descrease the
scale some of my values go off the end of the chart.

What I really want to happen is that the chart takes up a greater vertical
proportion of my plot area as the horizontal proportion has already been
maximised

Thank you

Matt


"Andy Pope" wrote:


Hi,

To adjust the scale double click it and on the axis tab you can set the
min and max values.

Cheers
Andy

Matt wrote:

Hi Everyone

I have a chart that looks good if I've only got a few items on the category
(x) axis (for days). However when I include more days the height of the chart
decreases leaving a lot of white space at the top and bottom of the chart. I
have increased the chart size but this only helps a bit.

I think what I need to do is somehow change the feature that automatically
sets the vertical scale so I can set it to manual. I realise that this will
change the relationship between the X and Y axis but this is what I want to
do.

Hope this make sense and someone can help

Thank you

Matt


--

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


--

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

Increasing the Vertial Size of a 3-D Line Chart
 

That's the one!

Thank you very much indeed

Matt


"Andy Pope" wrote:

Try this, Right click the chart and pick the 3d View.
On the dialog set the Height % of base to 300.

Cheers
Andy

Matt wrote:
Hi Andy

Sorry I obviously haven't made myself very clear here. If I increase the
scale I just get more values within the same chart area. If I descrease the
scale some of my values go off the end of the chart.

What I really want to happen is that the chart takes up a greater vertical
proportion of my plot area as the horizontal proportion has already been
maximised

Thank you

Matt


"Andy Pope" wrote:


Hi,

To adjust the scale double click it and on the axis tab you can set the
min and max values.

Cheers
Andy

Matt wrote:

Hi Everyone

I have a chart that looks good if I've only got a few items on the category
(x) axis (for days). However when I include more days the height of the chart
decreases leaving a lot of white space at the top and bottom of the chart. I
have increased the chart size but this only helps a bit.

I think what I need to do is somehow change the feature that automatically
sets the vertical scale so I can set it to manual. I realise that this will
change the relationship between the X and Y axis but this is what I want to
do.

Hope this make sense and someone can help

Thank you

Matt


--

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


--

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