Results 1 to 6 of 6

Using name formulas as a series in pie graph

Threaded View

gordian Using name formulas as a... 03-09-2010, 03:34 PM
teylyn Re: Using name formulas as a... 03-09-2010, 07:42 PM
gordian Re: Using name formulas as a... 03-09-2010, 07:48 PM
teylyn Re: Using name formulas as a... 03-09-2010, 08:09 PM
gordian Re: Using name formulas as a... 03-09-2010, 08:15 PM
teylyn Re: Using name formulas as a... 03-09-2010, 08:30 PM
  1. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Using name formulas as a series in pie graph

    see attached pie chart. You can not reference the data points for a chart from individual range names. You need to have the values in cells and create your pie chart off those cells. Of course, you can show the pie chart labels as percentages.

    As I said above, if you don't want the cells for the pie chart to show in this sheet, put them in another sheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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