Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create a chart with two set of data
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to create a chart with two set of data
case 1)
x values and two values in three columns side by side: Select all three columns of data and make chart case 2) x values and one y-value are in neighbouring columns but second y-range is elsewhe Select x and first y; hold CTRL; select second y; make chart case 3) two sets of x and y values: make chart from first set; select second set and Copy; activate chart; use Edit | Paste Special | New Series (check the box for x-values in first column) Hope this covers it. Please use the white space to ask questions in detail best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kenneth" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a chart with 4 sets of data? | Charts and Charting in Excel | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
Can I create a chart using every fifth row of data? | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
How to create a dynamic chart using data from every 7th data row | Charts and Charting in Excel |