| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel graph 3 sets of data. 2 sets as lines 1 as column?
I have data a bit like below, I am trying to do a graph, which shows the AFR
as columns for A-D, but I want 'water' and 'whole' as seperate lines to show current scores across the graph. When I do the graph, I get two columns and 1 line. Does anyone know how to get to get the two lines? A B C D AFR 0.8 0.6 0.4 0.3 Water 0.5 0.5 0.5 0.5 Whole 0.3 0.3 0.3 0.3 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel graph 3 sets of data. 2 sets as lines 1 as column?
Hi AndyN,
On the chart, select the second column, right-click, select Chart Type from the context menu, select line chart. Ed Ferrero www.edferrero.com |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel graph 3 sets of data. 2 sets as lines 1 as column?
Ed
Thanks for that worked a treat, I'll remember that one for future! Cheers Andy "Ed Ferrero" wrote: Hi AndyN, On the chart, select the second column, right-click, select Chart Type from the context menu, select line chart. Ed Ferrero www.edferrero.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Column 2 sets of data for 2 years | Charts and Charting in Excel | |||
| geographic map data sets in EXCEL | Charts and Charting in Excel | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| 2 different types of data sets displayed on 1 graph | Charts and Charting in Excel | |||
| anyway to go with excel two sets of data | Charts and Charting in Excel | |||
Hybrid Mode
