+ 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
    MS-Off Ver
    Excel 2003

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

    this is what I want to do


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


    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)


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