how do you change the way a series in plotted on a secondary axis

T

Tricia

I have a secondary axis chart. Is there a way to make all points one one
axis bars and all points on the second axis lines?
 
J

Jon Peltier

One by one, right click on each series, choose Chart Type or Change Chart
Type and change to the type you want.

- Jon
 

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

Overlaying 2 Data Series with Different Time (X) Axis 3
multiple series bar and line chart 2
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Scatter chart with categories on x-Axis 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Secondary Axis Data Series "Clumping" 3
Secondary axis not aligning to X axis 1
Assign data series to primary axis 1

Top