excel charts w/secondary Y axis

  • Thread starter Thread starter curtis
  • Start date Start date
C

curtis

I start with a scatter graph line chart, add the secondary
Y axis and save the chart. Then I noticed it is no longer
considered a scatter graph, rather it is a combination, so
I thought I'd be smart and change it back to the scatter
graph line chart, but my secondary Y axis disappears!
Why??
 
Add back the secondary Y axis, and ignore what kind of chart it thinks
it is. As long as both series are Scatter, you get the behavior you want.

Perhaps instead of calling it a combination chart (combined primary and
secondary axis?), Excel should tell you it's a customized chart.

- Jon
 
Ok, but when this happens to 19 charts...yikes,takes a
while, doesn't it??

also, is there a "global" setting for fonts in text boxes,
so if one wants to change the font you can do it in one
swell foop without doing each individual box??? (again
multi text boxes in 19 separate sheets......)
 
No global settings, but you could format one the way you like, select
it, and run this macro, which essentially runs the format painter on
each sheet's textboxes.

Sub TextBoxFormatCopyPaste()
Dim ws As Worksheet
Selection.ShapeRange.PickUp
For Each ws In ActiveWorkbook.Worksheets
ws.Select
ws.TextBoxes.Select
Selection.ShapeRange.Apply
Selection.ShapeRange.PickUp
Next
Selection.ShapeRange.Apply
End Sub

- Jon
 
Back
Top