+ Reply to Thread
Results 1 to 3 of 3

Conditional formatiing_feeding charts with formatted values

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    India
    MS-Off Ver
    7
    Posts
    0

    Conditional formatiing_feeding charts with formatted values

    Hi,

    I am looking for an unusual format. I am linking charts to a data set which is being filled by drop-down(using data validation). Only one of the list items (SAY P1) in the drop down needs to be represented as numbers and rest as percentages. To deal with this, I used conditional formatting and the result was fine.

    Now the only issue is that as the charts are linked to the cells and the same cells are being populated by choosing different list items from the drop down; when I select P1 in the dropdown, the table shows me values after conditional formatting but the charts are picking numbers as percentages which is the default number format for these cells. For eg. 4514 (after conditional formatting) is yet being picked as 4514795.80% in the line chart which looks like misrepresentation.

    Is there any way to feed the line charts with the values after conditional formatting, so that the line chart reflects it in number format and nor percentages (which is the default cell value). or in any way I can link these post formatting values to other cells and try linking charts to those cells.

    Please help out as I need this for an urgent presentation. Any help would be appreciated.

    Thanks.
    Aditi

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello aditi2810,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,688

    Re: Conditional formatiing_feeding charts with formatted values

    This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Conditional Formatting Pie Charts (non-numeric values)
    By Redjewel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-15-2013, 08:49 PM
  2. Replies: 6
    Last Post: 04-10-2013, 11:02 PM
  3. Count if cell is conditional formatted
    By marcopietro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2012, 04:15 AM
  4. Excel 2007 : counting conditional formatted cells
    By jrafols in forum Excel General
    Replies: 11
    Last Post: 07-02-2012, 10:12 AM
  5. Replies: 2
    Last Post: 08-16-2009, 06:16 PM

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