Editing Excel Chart

[Tracyice]

I have multiple charts in excel and I would like to make them all of the same size. Is there an easy way of doing this without manually changing all of them?

 

[misscrf]

Can you give more information? Are all of the charts on the same worksheet or seperate ones? Do they use the same data set/data source or different ones? Are they all the same type of chart ie bar or line , or are they different? I think that will help to troubleshoot...


misscrf

Management is doing things right, leadership is doing the right things

 

[Tracyice]

All charts are on the same worksheet. They use different data sources. They are all the same time of line graph. Thank you!

 

[SkipVought]

Hi,

Not without VBA code...

nHeight=100
nWidth=100

for each co in activesheet.chartobjects
  with co
    .width= nWidth
    .height= nHeight
  end with
next

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[SkipVought]

Tracyice,

I should have coded it more completely...

Sub ResizeCharts()
  nHeight = InputBox("Height in inches:") * Application.InchesToPoints
  nWidth = InputBox("Width in inches:") * Application.InchesToPoints

  For Each co In ActiveSheet.ChartObjects
    With co
      .Width = nWidth
      .Height = nHeight
    End With
  Next
End Sub

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}