Stop graph from shrinking when hiding rows or columns

J

JAbels001

I have Office 2007 and everytime I hide a column of cells or two the graph
that is overlapping those columns shrinks. How can I avoid this?
 
J

JAbels001

I have Office 2007 and I cannot find those options. Under "Layout" there is a
properties button but it does not give those options, only allows me to name
it...?
 
J

JAbels001

I found the solution: You can click on the chart -> select "Format" at the
top -> click on the Size options and choose to have the chart not change when
cells are changed. Thanks!
 
A

AR

I tried to click on the chart, which is on the separate tab - and 'Format',
then size - but it doesn't give the 'choose to have the chart ont change,
when cells are changed' - could it be that I am working on a 2003 file in
2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Excel 2002, problem with Text to Columns 0
Extracting data from spreadsheet to a graph 1
Format column widths from one table to a separate table on same page 1
Two columns : Continuous two columns vs Parallel two Column 1
Need Help with a VBA subroutine 0
Copy column from different sheets and plot a graph 3
Graphing Question: Blank Lines Problem ? 2

Top