+ Reply to Thread
Results 1 to 2 of 2

Produce Chart from Data

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    1

    Produce Chart from Data

    Hi All,

    i need to produce a chart from data in a 2 column table. In my table are items A, B and C, but the difference is that they occur more than once. For Example:

    A 5.50
    B 3.25
    A 7.56
    C 23.90

    i have a list of items and what they cost. Can i formulate a table fro mthis data where it auto adds the same items 'A' instead of catagorising them twice. Or woulsd i have to collate the data first? so add all item 'A's then formulate my chart from this collated data? if so, how do i ask a column to count 'All item 'A's'?

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Produce Chart from Data

    Hello and welcome to the forums.

    Your easiest solution is to create a pivot table of your data and then from the pivot table create a chart from the pivot table.

    It can sum or count your data however you need.

+ 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