Creating dynamic chart with dates and dollars

**penny** · 01-23-2009, 05:35 PM

Hello -

I've created a dynamic chart that is comparing dates vs. dollars spent. I sometimes have multiple entries per day. I'd like the chart to show me one value for a day.

Example:

01/12/2009 $12
01/12/2009 $15
01/12/2009 $17

Chart would show $44.

How can I make this work?

Thank you for the help!

**Andy Pope** · 01-24-2009, 09:55 AM

You need to summarize you data before you chart it.

Summarize with formula such as SUMIF or SUMPRODUCT.
Or consider pivot tables and chart

**penny** · 01-29-2009, 03:14 PM

I went with a pivot table, thank you.

**penny** · 01-29-2009, 03:56 PM

Well, I liked the pivot table, until it came time to do the charting. It's not friendly at all. I have approximately 300 rows of data with dates. The X-axis has all the dates piled on top of eachother and it really just looks terrible.

I have attached an example dynamic table that I would like to make a dynamic chart from. I would like to have 3 data series, based on Blue, Orange, and Red categories. I want my X-axis to have dates, with the Y axis having dollar amounts. I am able to create a dynamic chart with one series that ignores Blue, Orange, and Red, but it's not what I need. I am banging my head against a wall with this one.

I really appreciate the help!