View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
GeoFru GeoFru is offline
external usenet poster
 
Posts: 1
Default Excel graph where series-label is a part of the data

I have data, where the series name (the Label, below, like 1024, 2048) is
part of the rows of data.
Let's say the 1,2,3 are the months to guide the plot on the x-axis.
The data to plot is the 0.41, 0.47, etc.
Q: How to plot, showing the labeled series, without a lot of cut and paste
(Imagine 200 rows!).

Best case would be 3 series, in a line chart.
In XL2007, I can get the graph, but then need to go back to each series to
add the cell-reference for the series name. If I go to the fomula bar, I can
paste in and modify for each series, but still very tedious.

The data, for example:
1024 1 0.41
1024 2 0.47
1024 3 0.49
1024 4 0.5
1024 5 0.51
1024 6 0.51
1024 7 0.51
1024 8 0.51
1024 9 0.52
1024 10 0.52
2048 1 1.16
2048 2 1.45
2048 3 1.53
2048 4 1.64
2048 5 1.7
2048 6 1.74
2048 7 1.75
2048 8 1.78
2048 9 1.83
2048 10 1.86
4096 1 2.67