Line - Column 2 Axis

  • Thread starter Thread starter Michael C
  • Start date Start date
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
 
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
 
Back
Top