ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart won't resize correctly (https://www.excelbanter.com/charts-charting-excel/201755-chart-wont-resize-correctly.html)

Molly

Chart won't resize correctly
 
I have a very basic graph with lots of excess white space I can't get rid of
at the bottom. No resizing bars appear any where except for the entire plot
area. I've recreated the graph without any luck. I need to get rid of the
white space in order to balance the appearance. This hasn't happened with
more complex graphs.

Any help would be appreciated.

Jon Peltier

Chart won't resize correctly
 
Can you select the plot area (the rectangle in the middle of the chart) and
resize that within the chart area?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Molly" wrote in message
...
I have a very basic graph with lots of excess white space I can't get rid
of
at the bottom. No resizing bars appear any where except for the entire
plot
area. I've recreated the graph without any luck. I need to get rid of
the
white space in order to balance the appearance. This hasn't happened
with
more complex graphs.

Any help would be appreciated.




Molly

Chart won't resize correctly
 
I apologize - I wasn't very clear. It is excess white space at the bottom of
the plot area itself that I can't get rid of. Resizing only makes the graph
inside smaller or larger but does nothing to get rid of the blank area. I've
tried rotating the axis names to see if that had any effect - it didn't -
just made everything proportionally larger or smaller.

"Jon Peltier" wrote:

Can you select the plot area (the rectangle in the middle of the chart) and
resize that within the chart area?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Molly" wrote in message
...
I have a very basic graph with lots of excess white space I can't get rid
of
at the bottom. No resizing bars appear any where except for the entire
plot
area. I've recreated the graph without any luck. I need to get rid of
the
white space in order to balance the appearance. This hasn't happened
with
more complex graphs.

Any help would be appreciated.





Shane Devenshire

Chart won't resize correctly
 
Hi Molly,

You could try double-clicking the Y-axis and changing the Minimum value on
the Scale tab.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Molly" wrote in message
...
I apologize - I wasn't very clear. It is excess white space at the bottom
of
the plot area itself that I can't get rid of. Resizing only makes the
graph
inside smaller or larger but does nothing to get rid of the blank area.
I've
tried rotating the axis names to see if that had any effect - it didn't -
just made everything proportionally larger or smaller.

"Jon Peltier" wrote:

Can you select the plot area (the rectangle in the middle of the chart)
and
resize that within the chart area?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Molly" wrote in message
...
I have a very basic graph with lots of excess white space I can't get
rid
of
at the bottom. No resizing bars appear any where except for the
entire
plot
area. I've recreated the graph without any luck. I need to get rid of
the
white space in order to balance the appearance. This hasn't happened
with
more complex graphs.

Any help would be appreciated.





Molly

Chart won't resize correctly
 
Thank you, but that didn't work either. What I finally ended up doing was
adding in a second set of unneeded data which, for reasons I don't
understand, then allowed me to adjust the plot size and move the chart title
up. I then deleted the unnecessary data, and now the data is visually
balanced.



"Shane Devenshire" wrote:

Hi Molly,

You could try double-clicking the Y-axis and changing the Minimum value on
the Scale tab.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Molly" wrote in message
...
I apologize - I wasn't very clear. It is excess white space at the bottom
of
the plot area itself that I can't get rid of. Resizing only makes the
graph
inside smaller or larger but does nothing to get rid of the blank area.
I've
tried rotating the axis names to see if that had any effect - it didn't -
just made everything proportionally larger or smaller.

"Jon Peltier" wrote:

Can you select the plot area (the rectangle in the middle of the chart)
and
resize that within the chart area?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Molly" wrote in message
...
I have a very basic graph with lots of excess white space I can't get
rid
of
at the bottom. No resizing bars appear any where except for the
entire
plot
area. I've recreated the graph without any luck. I need to get rid of
the
white space in order to balance the appearance. This hasn't happened
with
more complex graphs.

Any help would be appreciated.






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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com