| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i create a chart with 4 sets of data?
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how do i create a chart with 4 sets of data?
I have four sets of data. One column is the major X axies and the second is
the Y axies. The third and fourth columns are data points the correspond with each of the major axies. How do I graph this in an area chart or XY scatter? "Bernard Liengme" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to create an Excel chart with 5 sets of variables | Charts and Charting in Excel | |||
| Two Sets of Time Data - One Chart | Charts and Charting in Excel | |||
| How to chart 3 sets of data? | Charts and Charting in Excel | |||
| I want to overlay three data sets in the same chart | Charts and Charting in Excel | |||
| Two sets of data on one chart | Excel Discussion (Misc queries) | |||
Linear Mode
