Add line to horizontal bar chart

G

Guest

I've made a bar chart with horizontal bars (the Y axis running from left to
right as you look at the screen). I would like to convers my second series
from a bar to a line, but whatyever I do Excel seems to create it on a
secondary Y axis that is vertical. When I go into 'format data series' it
won't let me plot it on the primary axis as the whole thing is greyed out.

Can anybody help me? I'm working in Excel 97 by the way.
 

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

Odd chart type needed 2
Creating a Combination Bar Chart with 2 Lines 1
multiple series bar and line chart 2
vertical scale on both ends of bar chart 1
Bar Chart with Secondary Line 1
Help with Bar-Line Chart..not aligned?? 1
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Assign data series to primary axis 1

Top