Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

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.