+ Reply to Thread
Results 1 to 1 of 1

=SERIES and charts (adding two cells in a series formula)

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question =SERIES and charts (adding two cells in a series formula)

    Hello
    this is what I want to do

    Excel.PNG

    I want to make a Pie chart that will list like this

    chart.PNG

    I'm wanting to know how i can have it combine cells B1 and E1 , B2 and E2, etc
    so that the total will show up in the pie chart

    so as the data say i want the pie chart to show

    Pennies 24
    Nickels 0
    Dimes 6
    Quarters 3

    I know that I could cheat and just make a area in my sheet with the grand totals but was wanting to know if there is a different way
    Attached Images Attached Images

+ 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