Add data to excel series

W

Walt

I receive daily API transation data. Each day the data is
provided via a text file. Data is in columns. First column
is date, second column is API (35 different APIs), third
column is transaction volume and fourth column is average
response time. I would like to create a chart with date on
the x axis, transaction volume on the y axis, and each API
as its own series. I can create a base chart for a single
day with all series. I am having a problems adding in
addition series data for each additional day? Is there an
easy way to add data to each series?
 
T

Tushar Mehta

Create a PivotTable (and PivotChart). Experiment with the day / API as
a row/column field to get the desired effect.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 

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

Dynamic series in rows 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Overlaying 2 Data Series with Different Time (X) Axis 3
Employee Schedule not plotting properly - chart type / data series not correct 0
Help with Bar-Line Chart..not aligned?? 1
Chart data scrunches to left when adding X axis date series 0
How do I adjust marker spacing in Excel scatter plot? 1
adding trendline to plots from multiple series 1

Top