+ Reply to Thread
Results 1 to 3 of 3

Help on Excel Chart

  1. #1
    Registered User
    Join Date
    05-27-2005
    Posts
    3

    Thumbs up Help on Excel Chart

    First, off I would like to say that I'm glad to be here and will try to help as much as I can and hopefully do a lot reading and learn.

    My questions is, if you have this:

    Business1
    Business1
    Business1
    Business1
    Business2
    Business2
    Business3

    I need a formula/column chart that will show on the bottom (x) axis business 1,2,3, and y (axis) how many times it was listed.

    business1/listed 4 times.
    business2/listed 2 times.
    business3/listed 1 time.

  2. #2
    Forum Contributor Kieran's Avatar
    Join Date
    10-02-2003
    Location
    Perth, Western Australia
    MS-Off Ver
    Office 2003
    Posts
    109
    NewGuy,

    This can be achieved with a pivot table / pivot chart.

    Hightlight the list of business names.
    Go to the data menu and select pivot table nad pivot chart report.
    Click finish.
    You should see teh pivot table field list.
    Drag the business name from this box, to the left hand side of the grid lines drawn on the new worksheet.
    Then drag the business name from this box to the large area in the lower right of the grid lines.

    That should give you the counts you want.

    To graph them, hit the graph button on the pivot table toolbar.

    Now that is pivot tables 101, it is a very powerful tool in excel , but a little tricky to learn. I suggest you look at the help files and ask theforum if you have more questions.

    Good luck
    Kieran

  3. #3
    Registered User
    Join Date
    05-27-2005
    Posts
    3

    Talking

    Kieran,

    Worked like a charm!

    Thank you so much.

    Next questions is, how can I create another chart showing the top ten repeating businesses.

    Looked at it again. How can you sort a pivot table or create from the pivot table the top ten repeating stores.

    Any help would be appreciated.

    NewGuy
    Last edited by NewGuy; 05-27-2005 at 02:16 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1