Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph in Excel has one data label missing Ellen Charts and Charting in Excel 2 April 2nd 23 08:06 PM
Data Series Label Positioning Thomas M. Charts and Charting in Excel 5 May 18th 09 11:37 PM
Data Tables Series Label Glyn[_2_] Charts and Charting in Excel 1 October 15th 07 02:30 PM
excel data label format special number characters (part 2) todd Excel Discussion (Misc queries) 1 May 4th 05 04:08 PM
how do I change the data series an an excel graph Deb Charts and Charting in Excel 1 February 1st 05 03:05 AM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"