How to chart data like this?

M

Michael D'Angelo

Does anyone know how I would chart data that is in this format? It is data
coming out of a database:

Series1 Date1 Value1
Series1 Date2 Value2
Series1 Date3 Value3
Series2 Date1 Value1
Series2 Date2 Value2
Series2 Date3 Value3

I want it to be a line or X/Y where the first column is the series name, the
second column is the X axis, and the 3rd is the Y.

The only way to create it seems to be to set up each series manually.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series display order sequential, not grouped side-by-side 2
secondary axis chart 0
Removing 0 in Stacked Column Chart 2
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ?? 1
In excel scatter plot with 2 series, how do I connect xy coordinat 2
Is is me? Or is Excel 2007 Charting Lame? 13
connecting two chart lines 2
Help with Scroll and Zoom Bar for Candle Chart 4

Top