+ Reply to Thread
Results 1 to 2 of 2

How do I put this information in a graph?

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Utah
    MS-Off Ver
    2007
    Posts
    42

    How do I put this information in a graph?

    I am new to using charts and graphs in excel and this may be super simple, but if someone could walk me through, that would be great!
    I have a simple list (see attachment) that I would like to keep exactly how it is. I want the (pie) graph to show each different category and the total amount spent in that category. I'm sure it's easily done by re-sorting the data and putting it all into the same rows, but like I've already mentioned, the data needs to stay where it is. It seems redundant to create a new list just for the chart. I don't see a way to use formulas for the pie graph, so please help me out if you can!!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: How do I put this information in a graph?

    You have to have a new list just for the chart, but it is based on the data you have. You will have to extend this list every time you add more categories. I have used the default pie chart, you may want to modify the formatting.

    Unfortunately the organization of your data is very unfriendly.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to chart this information - Bar Graph
    By DeborahClark in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-03-2015, 08:52 PM
  2. Plotting information on a Graph
    By Excelophobe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-23-2014, 09:38 AM
  3. how would you graph this information
    By ammartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-17-2014, 12:35 AM
  4. Use Information between two columns in Excel and generate graph
    By peels2141 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2013, 09:32 AM
  5. Use Information between two columns in Excel and generate graph
    By peels2141 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2013, 04:30 AM
  6. How do I update a graph weekly in excel without overwriting past week information
    By nconsola in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2013, 02:11 PM
  7. Can't print graph with spreadhseet information
    By dominikgomez in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2005, 10:05 PM

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