+ Reply to Thread
Results 1 to 11 of 11

Add callout for today temperatures only

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Add callout for today temperatures only

    Hello everybody,
    Could you help me in my question,please?
    My File is about piles temperatures of a material and there is a chart of it.
    I have a code in my file that can create a callout(that shows company) for every point in the chart that is greater than 44 with no repeat.
    I need to edit the code to add the callout for today temperatures only that exceeds 44.
    Please help me
    Attached Files Attached Files
    Last edited by leprince2007; 12-15-2021 at 05:34 PM.

  2. #2
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Please help
    Pump... Pump

  3. #3
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,419

    Re: Add callout for today temperatures only

    like this ???
    If you take the highest temperature on the first day or the highest temperature today, the labels have less chance to overlap.
    Attached Files Attached Files
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  4. #4
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Thanks bsalv for your solution but there are some modifications:
    1-No helper columns are required because I will run the code on a lot of charts and my sheet contain a lot of data.
    2-I want to show today`s points only.
    3-I want the callout to be full name "Company 1" not a abbreviation and with white color.
    Thanks in advance
    Last edited by leprince2007; 12-18-2021 at 05:52 AM.

  5. #5
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,419

    Re: Add callout for today temperatures only

    as demanded, several lines are now "comment"
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Thanks bsalv for your solution.But I tried it on my data ,I got 2 problems:
    1-There are a lot of useless callouts in the chart that contain date only
    2-The code create callouts for half of today`s points.

    See the attachment
    Please help me to fix it
    Thanks in advance
    Attached Files Attached Files
    Last edited by leprince2007; 12-22-2021 at 05:45 AM.

  7. #7
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Please help me
    Bump....Bump

  8. #8
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,419

    Re: Add callout for today temperatures only

    for one or another reason, in 1 serie the "category name" was displayed without interaction.
    So you find now a line, that disables that
               .DataLabels.ShowCategoryName = False '----> don't show the categoryname in the datalabel
    Because at that moment, i didn't know this cause, i added a sheet with the name of the chart, the serie, the "hot" point and all its parameters.
    Perhaps this can help you for other purposes.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Thanks it works great but I need one last thing to remove the callout "Limit" in all charts.
    Thanks in advance

  10. #10
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,419

    Re: Add callout for today temperatures only

    a piece of cake, i thought, but the seriename was " Limit" instead of "Limit", small but important difference.
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    774

    Re: Add callout for today temperatures only

    Thanks
    solved

+ 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. VBA code to create a chart for every company`s Temperatures
    By leprince2007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2021, 04:45 PM
  2. VBA to update date ranged cells to 5 day temperatures
    By Herostuff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 02:33 PM
  3. Replies: 3
    Last Post: 01-04-2014, 05:32 PM
  4. Replies: 7
    Last Post: 12-25-2012, 08:54 PM
  5. [SOLVED] Consecutive Days in a row of temperatures >= 90 degrees
    By redchair in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-21-2012, 02:28 PM
  6. Reading dates for highest/lowest temperatures
    By CMG1 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-21-2009, 05:33 PM
  7. find the high temp of the day from may temperatures per day per month
    By mrbojangles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2008, 01:29 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