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

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

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

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

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