View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default how do i create a chart with 4 sets of data?

Create a column chart of all four data series
Right click on one in the chart; select Chart Type and convert to line
Repeat with second data series
Right click one of the data series; Format Data Series and specify Secondary
y-axis
Repeat with second data series
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"PK" wrote in message
...
I have to create a graph holding 4 sets of data, two bar charts and two
line
graphs. The other problem is that they are measured in different units -
is
it even possible to plot this on a single chart?