Unable to Add More Data to Chart

Question

I am looking to add more data to chart, but it seems everything is grey out. I know I have done this before, but it's been awhile... seems there's an issue with the original data being in a table... it automatically grabs ALL data from the table and won't let me add/delete some of the data in the chart. Here's a screen capture:

The situation: my son has a 'youth' bank account and initially it charged him a small monthly service fee of $3.90 per month, but then also credited that same amount back to his account. In other words, the net expense to him was nil.

However, about 2.5 years into it, the bank stopped crediting back that service charge expense of $3.90--he began incurring the expense only as there was no longer any credit back.

I am trying to graph out the service charge expense along with the credit back, and to then show when the credit dropped off.

If anyone can point me in the right direction, that would be much appreciated--many thanks in advance!

Answer 1

If you put Receipts and Disbursements in the same table and then create one pivot table I think things will work.

Shane Devenshire

Answer 2

Hi Shane - thanks, I'll give that a try. I guess Excel is a moving away from more than one source of data to feed into a chart/graph, which kinda sucks. Thanks again.

Answer 3

Hi kgriba2011：

May I know whether there are any updates to your question? If you have any questions, please feel free to contact us.

Tin

Answer 4

Hi Tin - I gave a try to Shane's suggestion, which was a lot of work as I had to combine two sets of data into one set of data; in the end it did work for me, in this instance.

That said, my question was not answered--I would still like to know how to pull from more than one source of data into one chart/graph? I'd like to get this figured out as I know this will eventually come up again.

Thanks for checking in, Tin.