Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart series (based on datarange content)
I copied this thread from Miscellaneous forum, but I don't know how to delete the original thread (http://www.excelforum.com//showthread.php?t=563052). I am trying to create a chart, which will show how execution times of certain methods change 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=563065 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart series (based on datarange content)
Can anybody help with this problem? -- alecswan ------------------------------------------------------------------------ alecswan's Profile: http://www.excelforum.com/member.php...o&userid=36554 View this thread: http://www.excelforum.com/showthread...hreadid=563065 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart series | Charts and Charting in Excel | |||
How to select numeric 'series axis' in a surface chart? | Charts and Charting in Excel | |||
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 | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel |