Pls help me again!

D

davidiew

So sorry earlier I had forgotten my attachment file. Thanks Karran.

Hi there! Good morning.

I have a problem here, hope you guys and gils can helps me. Thanks!

I need to show some details from a table (file attached
stationary123.xls) using bar chart. so that I can see the number o
different items (ex: book, knife or ruler) with 2 bars for types A &
every month.

Do you think msExcel can do that?
Or you think I should put it in some others way or modify my table?

Thank you very much.

davidie

Attachment filename: stationary123.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53700
 
D

DNF Karran

Change the format to database style table with 4 headings-
Month Item Group Amount

You can then create a pivot table with pivot chart. If you play wit
the field locations it will change your graph so you can get what yo
want.

Duncan

Attached exampl

Attachment filename: stationary123.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53702
 

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

Pls help me ! 1
Pls Help Me! 5
Pls Help Me! Creating Chart 1
Almost worked - :( 1
Chart of frequences of values 3
Pls Help Me!! 2
How to get rid off duplicate items? 5
how to sort the data display order of multiple chart 1

Top