Excel Graph

[north2060]

Could someone tell me how can I create 2 bars and 1 line chart from 3 sets of data? for example:

%Male %Female Index
Asia 49% 51% 89
Europe 52% 48% 180

 

[GlennUK]

If you mean that you want two series with bars ( columns ), and a series of a line in the same chart, then select all the data to create a column chart with 3 series ( data in columns ). Once the chart has been created, select the "Index" series, and do menu command Format/Series/Axis, and choose secondary axis. Now use the Chart Type drop-down from the Chart toolbar to change the series to be a line chart, and hey presto, you're finished.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.