Problems with Secondary X Axis

J

Jack

Jon

Hi, Thanks for the quick response. but I am using 2 series
and both are scatter charts.
Also I can't get the x-axis secondary to be an option.

This is the code I used:

ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).XValues = "=hpepupperf!
R6C20:R75C20"
ActiveChart.SeriesCollection(2).Values = "=hpepupperf!
R6C18:R75C18"
ActiveChart.SeriesCollection(2).Select
ActiveChart.SeriesCollection(2).AxisGroup = 2
With ActiveChart
.Axes(xlCategory, xlSecondary).MinimumScale = _
.Axes(xlCategory, xlPrimary).MinimumScale
.Axes(xlCategory, xlSecondary).MaximumScale = _
.Axes(xlCategory, xlPrimary).MaximumScale
.Axes(xlCategory, xlSecondary).MajorUnit = _
.Axes(xlCategory, xlPrimary).MajorUnit
End With
 

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

reverse axis not working as before... 0
#N/A isn't charting in VBA 2
Help on adding the second trendline in a "lines on 2 axes" Chart via VBA 1
Problems with Secondary X Axis 3
"Lines on 2 Axes" fails on Excel 2007 1
add a chart in a Add-In 1
Secondary axis with VBA 1
x-axis scale changes 3

Top