Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a 3-columns table (Date,Time,Value). I would like to automatically plot the table using the following format:

  • X-axis: Time
  • Y-axis: Value
  • Series: Date

This would give me a different line for each day.

I only managed to do it manually (adding a new series for each day), yet I want it to be automatic, i.e. create a new line for every new value in the first column.

How can I do that?

share|improve this question
up vote 1 down vote accepted

If you don't mind a little coding, you could try something like this:

VBA to Split Data Range into Multiple Chart Series

share|improve this answer
Ok, seems fine to me, it would be great if I could trigger the macro on external data update. Is that possible? – gregseth Jan 29 '12 at 20:38
You could call the code from within a Worksheet_TableUpdate, Worksheet_PivotTableUpdate, Worksheet_Change, or Worksheet_Calculate event. – Jon Peltier Jul 20 '15 at 13:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .