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

Adding a line to a bar chart 1
Hide Cells with Zero Value in Excel 2007 while using line chart ty 4
How do I get a chart to only display the dates in my table? 1
Bar Chart To Line Chart for last 3 points only 1
Chart Increments -- to expand 2
Can I combine a stacked bar with regular bars on the same chart? 5
max number of data ranges (bars) in a bar chart 5
How to include variance data in the chart table but not on the gra 1

Top