How to make a chart for a days sales...?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

ok, I have a list of transactions by day, like so:

01/07/2007 £ 13.99
01/07/2007 £ 92.46
03/07/2007 £ 56.94
04/07/2007 £ 69.99
04/07/2007 £ 29.96
04/07/2007 £ 19.98
05/07/2007 £ 64.68
05/07/2007 £ 38.94
06/07/2007 £ 19.98
06/07/2007 £ 39.96
06/07/2007 £ 67.95
06/07/2007 £ 27.98
07/07/2007 £ 67.95
08/07/2007 £ 19.98
08/07/2007 £ 67.95


I want to draw a bar chart show total sales per day (eg. £106.45 on day 1,
£0 on day 2, £56.94 on day 3 etc). How do I configure this given the above
data? I don't mind adding extra columns and formulas if required, as long
as it works it all out it self (the real list is very long and the number of
transactions per day varies.
 
Hi Bob

Insert a header row with Date in A1 and Value in B1
Mark the block of data>Data>Pivot Tables>Finish
On the new sheet that is created, drag Date from the field list to the Row
area
Drag Value from the field list to the Data Area.
That is your data summarised by date.

On the Pivot Table Toolbar, click the Graph Icon and you will have a chart
of your data.

For more help on Pivot Tables, take a look at Debra Dalgleish's site and
scroll to the area on Pivot Tables
http://www.contextures.com/tiptech.html
Also look at the section on Dynamic Ranges to ensure that as your data
expands, it will automatically be included in the Pivot Table and Pivot
Chart.
http://www.contextures.com/xlNames01.html#Dynamic
 
Back
Top