Chart: need help with my first simple chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1500159%22%20slang%3D%22en-US%22%3EChart%3A%20need%20help%20with%20my%20first%20simple%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500159%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMy%20spreadsheet%20has%20many%20columns.%20I%20want%20to%20chart%20Column%20A%20on%20the%20horizontal%20X%20axis%20to%20showing%20all%20the%20dates%2Fdays%20we%20received%20donations%2C%20and%20I%20want%20to%20Column%20T%20to%20appear%20on%20the%20vertical%20Y-axis%20showing%20the%20amount%20of%20money%20received%20that%20day.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20would%20like%20to%20create%20a%20bar%20chart%20that%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E1.%20Has%20a%20vertical%20bar%20showing%20the%20total%20donations%20for%20a%20specific%20date%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20The%20dates%20run%20across%20the%20horizontal%20access%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3.%20The%20Dollar%20amount%20runs%20up%20the%20vertical%20access.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EMy%20spreadsheet%20might%20have%2012%20donations%20received%20on%206%2F12%2F2020%2C%20and%209%20donations%20received%20on%206%2F15%2F2020%2C%20etc.%20My%20spreadsheet%20does%20not%20show%20total%20donations%20received%20on%20any%20one%20day.%20It%20just%20gives%20a%20record%20for%20each%20donation%2C%20and%20so%20if%20I%20had%20five%20donations%20on%206%2F12%20then%20they%20would%20each%20have%20the%20date%206%2F12.%20I'm%20hoping%20the%20chart%20can%20add%20up%20the%20totals%20for%20each%20date.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1500159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

My spreadsheet has many columns. I want to chart Column A on the horizontal X axis to showing all the dates/days we received donations, and I want to Column T to appear on the vertical Y-axis showing the amount of money received that day. 

I would like to create a bar chart that:

1. Has a vertical bar showing the total donations for a specific date
2. The dates run across the horizontal access
3. The Dollar amount runs up the vertical access.

My spreadsheet might have 12 donations received on 6/12/2020, and 9 donations received on 6/15/2020, etc. My spreadsheet does not show total donations received on any one day. It just gives a record for each donation, and so if I had five donations on 6/12 then they would each have the date 6/12. I'm hoping the chart can add up the totals for each date.

0 Replies