+ Reply to Thread
Results 1 to 3 of 3

Match chart data labels color with table dataset and add % on top of data lables

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Match chart data labels color with table dataset and add % on top of data lables

    Hello friends,

    I am trying to draw a chart where I need to add percentages in data labels exactly on top of data values and I also want to color the data labels based on what color it has in the data set which is based on a conditional formatting. File attached with this post. I googled for some resource and I did get some idea however, all these ideas were working if additional temporary cells/columns were added and I do not want to add anything extra because I have set a printer friendly alignment in my file which I do not want to disturb. Appreciate some help here. Thank you.

    In the attached file:

    There are two tables given in the file. Second table is inserted only for demo purpose It is not there in my actual file. I do not want to draw the second table.
    Conditional formatting in first table is based on benchmark given in column H

    Question 1
    Without adding any additional table or column, the data labels percentage should show on top of the data labels in chart 1. The percentage should be calculated based on the 'Out of marks' values in row 2 without calculating the percentage in any temp cell.

    Question 2
    I want the data labels color to match with data set color which is based on the benchmark. If benchmark is changed, the color of data set in the table and data labels in the chart both should change automatically.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Re: Match chart data labels color with table dataset and add % on top of data lables

    Any idea??

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    India
    MS-Off Ver
    MS Excel 2007
    Posts
    240

    Re: Match chart data labels color with table dataset and add % on top of data lables

    Havent got any reply on my post. Is this not possible in excel?
    Thanks

+ 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. [SOLVED] Chart Data lables positioning VBA
    By Journeyman3000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2014, 06:41 PM
  2. Variable Data Match From Dataset
    By finchy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2013, 04:29 PM
  3. Excel 2010 stacked bar chart: Color coding data labels
    By kashifmehmood in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2013, 06:37 AM
  4. Can I change the color of labels in a 3D pie chart to match cell colors?
    By Macphersonian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 12:07 PM
  5. [SOLVED] X-Axis labels disappear when adding data table to chart
    By phacexcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2012, 02:37 PM
  6. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  7. Column Chart w/ Percentage and Text Data Lables
    By Raisedwell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2010, 11:35 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