A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Increasing the Vertial Size of a 3-D Line Chart



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 11:36 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

  #2  
Old February 22nd, 2006, 02:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
  #3  
Old February 22nd, 2006, 03:06 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

  #4  
Old February 22nd, 2006, 03:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
  #5  
Old February 22nd, 2006, 03:40 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
chart size zdenek Charts and Charting 0 February 9th, 2006 10:58 AM
Line Chart Randy K. Setting Up & Running Reports 0 November 14th, 2004 08:09 PM
Conditional Chartting Os Charts and Charting 14 October 16th, 2004 01:12 PM
Excel 2000 Line Chart Problem...HELP !!!! Tushar Mehta Charts and Charting 2 May 13th, 2004 12:12 AM
How to create stacked line chart with some empty value? Jon Peltier Charts and Charting 0 November 12th, 2003 07:35 PM


All times are GMT +1. The time now is 10:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.