Line - Column 2 Axis

M

Michael C

I have a table with 4 columns and I want to show three
columns as bars on one axis and one as a line on the other
axis but the standard format always splits the table into
two bars and two lines. Even if I transfer the third
column into the primary axis it still stays as a line. Any
help will be great. Ta, Michael
 
A

Andy Pope

Hi Michael,

Best thing to do is create a Column chart based on all 4 data series.
Them select the data series that you want to plot as a line.
Right click and pick Chart Type from the popup menu.
Pick the appropriate line chart.

Michael said:
I have a table with 4 columns and I want to show three
columns as bars on one axis and one as a line on the other
axis but the standard format always splits the table into
two bars and two lines. Even if I transfer the third
column into the primary axis it still stays as a line. Any
help will be great. Ta, Michael
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 

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

One Column on 1st y-axis and 3 lines on 2nd y-axis 1
One extra x axis item that wont go away - can anyone help? 3
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Graphs: 2 Lines on secondary Y-axis? 1
Help with Bar-Line Chart..not aligned?? 1
sideways stacked bar charts with line series on the same axis 0
multiple series bar and line chart 2
In a Line-column graph on 2 axes, how do I stack the columns? 1

Top