How to craete a bar chart in excell

D

David

Hi i'm trying to make a bar chart in excel but i haven't used it
before.....

Suppose i had data like this:

Product | Price | Date of Purchase | Catagory
TV | $100 | 05/08/2004 | New
Computer | $300 | 05/08/2004 | Old
Fridge | $500 | 12/02/2004 | New

$900


I'm trying to graph data like this by 'catagory', in bar format.
So the graph function would need to first do a count of the occurences
of each type of catagory, and then graph it.
Can someone either give me a link, or tell me how to do this easily.
Thanks, David.
 
T

Tushar Mehta

Look into creating a PivotTable (with an associated PivotChart).
Alternatively, if you must roll your own, check out XL help for the
FREQUENCY function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Combine 2 Charts 2007 Excel 1
Data points in chart incorrect 0
Totals in the data table but not in the graph / chart 1
Excel 2007 charts: want to avoid zero values 1
error bars on bar chart in Excel 2007 1
Data Labels, Error Bars, and Dynamic Charting 1
Table and Chart 1
Combination bar/stacked charts 1

Top