Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart series (based on datarange content)
I am trying to create a chart, which will show how execution times of certain methods changed over time. Here is my data, the first column lists method names and the second execution times in milliseconds: find(), 100 create(), 200 find(), 75 find(), 125 create(), 250 I would like to create a chart, which has a separate series for each distinct method name and will show how method execution time chaged over time. So, in the case above, I would have two series: one - for find() method, another - for create() method. Each series will plot execution time for the pertinent method on the Y-axis and use sequential number for X-axis. So, for the example above, the first series will plot (1, 100), (2, 75), (3, 125) and the second series will plot (1, 200), (2, 250). I am not concerned about X-values as long as they are sequential. One caveat though, I would like to be able to run this chart against different data ranges, which can contain different sets of methods being executed. So, I don't want to MANUALLY create a separate series for each method, but instead would like the chart to figure out how many different method names are there and create a separate series for it. Thanks. Alec -- alecswan ------------------------------------------------------------------------ alecswan's Profile: http://www.excelforum.com/member.php...o&userid=36554 View this thread: http://www.excelforum.com/showthread...hreadid=563052 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I pass series data x-value range to a chart from a cell? | Charts and Charting in Excel | |||
How to display a series in chart table and not in the chart? | Charts and Charting in Excel | |||
Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
How to hide a dummy series in a chart legend? | New Users to Excel |