XL chart sizes

  MRMC 12:21 22 Mar 2008


I have a (self-created) accounts spreadsheet in Microsoft XL 2002. I set up various pie and bar charts (in separate workheets) to illustrate various items. The charts were all sized to fill each worksheet page.

All was fine, until one day I found all the charts had shrunk to become so tiny they are illegible! Despite much tinkering, reading of manuals and Google searches, I cannot work out how to re-size (i.e. enlarge) the charts!

Could you please help?

Many thanks!

  VoG II 12:42 22 Mar 2008

It is possible that the workbook is corrupted in which case the following might not work but worth a go.

Press ALT + F11 to open the Visual Basic Editor, Insert > Module. Copy and paste in

Sub ResizeCharts()
Dim cht As ChartObject, ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ThisWorkbook.Worksheets
For Each cht In ws.ChartObjects
With cht
.Height = 200
.Width = 200
End With
Next cht
Next ws
Application.ScreenUpdating = True
End Sub

then close the VBE using the X. Tools > Macro > Macros, highlight ResizeCharts and click the Run button. If successful this will resize every embedded chart to 200 x 200 pixels.

  MRMC 12:56 22 Mar 2008

Hi VoG.

Thanks for the quick response, but that didn't work.

  VoG II 13:01 22 Mar 2008

You could try the Open and Repair method click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?