Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.