• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 904
  • Last Modified:

Graphs no longer print to fit in Excel 2010

My company recently upgraded me to excel 2010.  I produce many graphs and in the older versions of Excel, I could select any graph and print it.  It would automatically scale vertically and horizontally to fill the page.  With 2010, this no longer works.  It only scales in one direction (maintains ratio), forcing me to re-scale and modify all graphs before I can print.  This interferes with the layouts I had for printing them as part of my workbook.  This is a lot of rework for nothing.  Is there a setting I am missing or some fix to this that can get my old functionality back?
0
mickeymo09
Asked:
mickeymo09
  • 12
  • 6
1 Solution
 
dlmilleCommented:
Is your chart embedded in the worksheet, or on a tab by itself?  or both?

Dave
0
 
dlmilleCommented:
Can you upload an example without confidential data?

Thanks,

Dave
0
 
mickeymo09Author Commented:
it is within the worksheet not a separate tab -
TEST-for-Printing.xlsx
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
dlmilleCommented:
How are you initiating the print?  By selecting the chart and then invoking print (for selected chart)?
0
 
dlmilleCommented:
See this link:  http://www.mrexcel.com/forum/showthread.php?t=43358

This walks through how to do it, but apparently it may not be a "feature" anymore.

I'll keep looking...  I used to use this approach as well -

See this:  http://excel.tips.net/Pages/T002849_Preparing_a_Chart_Sheet_for_Printing.html  apparently this feature may no longer be available as it says "prior to Excel 2007"

Sorry - I don't think this is possible.  But, if I find something I'll let you know.

Dave
0
 
mickeymo09Author Commented:
so the user will have to manually adjust the size of the graph to fit the page?
0
 
dlmilleCommented:
It seems so.  Though it might be possible to create a macro to hit all graphs and adjust aspect ratio to match the current paper size (if user doesn't save after - because they may not look good on worksheet after that)...

Dave
0
 
mickeymo09Author Commented:
thank you so much for your help...
0
 
Richard DanekeTrainerCommented:
Yes, that was convenient.

However, if you move the chart to its own worksheet  (last ribbon option on Design in Chart Tools group) Excel does scale the graph to fit the page.

Does each graph need to print on one page or do you resize several to fit on one page?
0
 
dlmilleCommented:
@mickeymo - Not so fast...  

Here's the macro I suggested could be done.  It moves all embedded macros to their own chart tab.  I could have stopped short of automatic print, as the user could select the charts together and print them (but I added it anyway).

Run the macro:  
Sub MoveToChartPrintAndReturn()
Dim myChart As Shape, mySheet As Worksheet

    For Each mySheet In ActiveWorkbook.Worksheets
        mySheet.Activate
        For Each myChart In ActiveSheet.Shapes
            On Error GoTo skipShape
                ActiveSheet.ChartObjects(myChart.Name).Activate
            On Error Resume Next
            ActiveChart.Location Where:=xlLocationAsNewSheet
            ActiveChart.PrintOut 'comment this line out if you want user to print, manually
skipShape:
        Next myChart
    Next mySheet
End Sub

Open in new window

It will move them all to a separate CHART tab (recall, this is what I asked, if the charts were embedded or not, DoDahD)

At any rate, this will go through the entire workbook and move charts to the chart tab.

Dave
MoveChartsAndPrint-r1.xlsm
0
 
dlmilleCommented:
It turns out this is better than working the aspect ratio.  I started on that and then recalled there's no reason they can't be in their own tab (as long as the user doesn't save the file, after!!!)

Dave
0
 
mickeymo09Author Commented:
print on one pge
0
 
dlmilleCommented:
Test it out.  The code should work for you.

Dave
0
 
mickeymo09Author Commented:
thanks dlmille i will run this macro and it should print the graph to fit the page correct?
0
 
dlmilleCommented:
Well, if they're embedded and you have selected a range behind several charts to print, then you're stuck back with the same can't do with Excel.  As, that can't be moved to a separate chart tab.

Dave
0
 
dlmilleCommented:
That is correct.  you can still setup margins and stuff with the macro, but first test and see if it works with the demo I gave you.

Dave
0
 
dlmilleCommented:
let me know how it plays out.

Cheers,

dave
0
 
mickeymo09Author Commented:
i will do first thing in the morning. thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 12
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now