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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
chart size | zdenek | Charts and Charting | 0 | February 9th, 2006 09:58 AM |
Line Chart | Randy K. | Setting Up & Running Reports | 0 | November 14th, 2004 07: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 06:35 PM |