+ Reply to Thread
Results 1 to 2 of 2

Macro to format data point and add label in chart

  1. #1
    Registered User
    Join Date
    10-18-2003
    Posts
    22

    Macro to format data point and add label in chart

    Hi,

    I have a basic column chart. For two of the data points, I would like a macro so that during a presentation I can easily highlight/reveal them. In the data series, I don't have them labeled anything ---it's just one column in the whole sheet----, I have named the two datapoint cells that I would like to highlight.

    Is there a code I can quickly call to format one red and the other yellow and also display the two values? Ideally, their would be a macro for each code so I can run them one at a time.

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Macro to format data point and add label in chart

    No need for code. Have a look at here,
    http://peltiertech.com/Excel/Charts/ChartByControl.html
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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