+ Reply to Thread
Results 1 to 5 of 5

Change automatically Data Label & Vertical Axis format based on data value format

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    658

    Change automatically Data Label & Vertical Axis format based on data value format

    Hi Experts,

    Please find here attached sample workbook, where i want to change automatically Data Label & Vertical Axis format in chart based on the drop down selection.

    I do have two Criteria 1) Hours and 2) Value for drop down selection. I have tried by applying conditional formatting as well for drop down selection. So if i do select Hours from the drop down then output will in Number format and if i do select Value then the output will in Currency format but it is also not displaying the required format.

    Request to you please help me on the same.

    Many thanks and regards,

    Neilesh

    Book2.xlsx

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,059

    Re: Change automatically Data Label & Vertical Axis format based on data value format

    Right click on the control and assign the following macro to it

    Please Login or Register  to view this content.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    658

    Re: Change automatically Data Label & Vertical Axis format based on data value format

    Hi dflak, Thank you so much for your precious support, In the provided script i made small change by adding $ sign ("Case "Value" NFormat = "#,##0" ) and now the data labels are getting change as per the format but the Vertical Axis value is still unchanged in both the selection from the dropdown.

    Is it possible to change the Vertical Axis Value format in Number format if i do select the Hours from the dropdown and Currency format if i do select Value from the dropdown.

    Once again thank you so much.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,059

    Re: Change automatically Data Label & Vertical Axis format based on data value format

    Change this line
    Please Login or Register  to view this content.
    To read
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    658

    Re: Change automatically Data Label & Vertical Axis format based on data value format

    Thank you dflak, Thank you so much for your precious support.

+ 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. Change format of particular Data Label of Pie Chart if condition is satisfied
    By ibdave19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 07:57 AM
  2. [SOLVED] How can I dynamically change the format of the Y axis based on the source data
    By rmeister29 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-22-2015, 10:43 AM
  3. Chart - Data Label Format Refuses to Change
    By TestMailinator in forum Excel General
    Replies: 2
    Last Post: 01-22-2015, 10:17 AM
  4. Cannot change axis label format
    By MiningCam in forum Excel General
    Replies: 1
    Last Post: 11-16-2014, 11:28 PM
  5. [SOLVED] Change data from vertical format to horizontal format
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2013, 07:06 PM
  6. [SOLVED] change format of number in vertical axis of chart
    By maacmaac in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2013, 02:56 AM
  7. [SOLVED] Is it possible to conditionaly format based on the data label?
    By David in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-22-2006, 11:55 AM

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