Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graph in Excel has one data label missing | Charts and Charting in Excel | |||
Data Series Label Positioning | Charts and Charting in Excel | |||
Data Tables Series Label | Charts and Charting in Excel | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
how do I change the data series an an excel graph | Charts and Charting in Excel |