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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 25 Jul 2007 18:57 GMT

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.

Reply to this Message

Roger Govier - 25 Jul 2007 19:30 GMT

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

Signature

Regards
Roger Govier

> ok, I have a list of transactions by day, like so:
>
[quoted text clipped - 19 lines]
> as long as it works it all out it self (the real list is very long and the
> number of transactions per day varies.

Reply to this Message

Rate this thread: