Want chart to display total of values

C

chipconnection

Hello,

I have 7 worksheets of credit card charges that I want to graph by date. My
data is in two columns in each sheet:

Date Balance
1/1/1998 $432.11

etc.

What I want is to have the total debt of all the cards charted along with
the debt of each card individually. The problem is that the dates of the
transactions varies widely.
I've tried to setup a pivottable and pivotchart to display this, but I am
not familiar enough with them to make it work right. Help! I want to track
how well I'm paying off my debt! :)

Thanks in advance,

-John
 

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

Filtered view of Visio Chart 0
Display weeks from a Milestone 0
How to create a bubble chart with more than 2 variables. 0
Dumb question alert! What program to use? 0
How to display zero value in blank fields of Cross Tab query 0
How do I track credit card debt on one spreadsheet? 1
Space at end of multi page list to accommodate new entries 1
Problem building horizontal bar chart paired bars, centered on zer 2

Top