+ Reply to Thread
Results 1 to 4 of 4

% and numbers on graph

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    % and numbers on graph

    I have a very simple series but I want the % and the $ amount on the graph. Right now I can select either/or but is there a method to doing this simply? I am trying to get it onto a basic pie chart (not pivot).

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: % and numbers on graph

    some sample data would be helpful.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: % and numbers on graph

    Quote Originally Posted by pawilsonliftone View Post
    I have a very simple series but I want the % and the $ amount on the graph... is there a method to doing this simply?
    Add data labels & include "series" and "percentage".

    See attachment for a simple demo series & screencaps of where the buttons are.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    Re: % and numbers on graph

    Thanks ben, I knew it would be increadibly simple.

+ 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. Using numbers as markers on a graph.
    By Dapos1993 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-11-2013, 10:12 AM
  2. [SOLVED] Two numbers one is percent of other - how to graph
    By MaddyG in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-22-2013, 10:55 AM
  3. Do not graph negative numbers
    By ScottL in forum Excel General
    Replies: 2
    Last Post: 12-13-2011, 02:12 PM
  4. Numbers on a Log scale graph.....
    By chrisbrez2002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2009, 11:57 AM
  5. Replies: 1
    Last Post: 02-16-2006, 04:00 AM

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