How to create chart with 1 column and 3 lines
 

IF
This type of chart not in Standarad or Custom Types.

THANK YOU

Hi,

Start by creating a standard column chart.
Now select 1 of the column series that you want as a line.
Right click and chose Chart Types. Select Line chart.
That should have now changed the data series to a line.
Select another column and this time press F4, which will repeat the last
action. Repeat for the final series.

Or maybe its easier to create a line chart of all 4 and the change 1
series to column using the same technique as above.

Cheers
Andy

agenda9533 wrote:
IF
This type of chart not in Standarad or Custom Types.

THANK YOU

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info