Maximizing width of graph

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I have a worksheet with two graphs which I want to print on one sheet of
paper. I would like to maximize the width of the graphs.

I've set the left and right PageSetup margins to .25", the Left of each
ChartObject to 0, and the PlotArea.Left to 0.

What ChartObject Width can I use to maximize the width, but not spill over
to a second sheet? If I want the width to be 8", what number does this
correspond to?

I tried using FitToPagesWide = 1 in the PageSetup, but it doesn't maximize
the width. It leaves about half an inch of space on the right.

Is it possible to get a graph to completely fill up the area between the
left and right margins?
 
It would depend on your printer and the drivers. AFAIK a laser will not
print to the edges. Try with text first....
 

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

Excel to Powerpoint 2003 Chart Width 2
Help with PageSetup for printing, please? 2
Question on Graph XLGraphType 1
parameter the axis of a graph 1
Method 'Height' of object 'ChartObject' failed 1
Graph Line Width ? 1
Creating graphs in VBA 3
Extend size of non client area 0

Back
Top