+ Reply to Thread
Results 1 to 2 of 2

Dynamically show latest value in line chart

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Dynamically show latest value in line chart


    I have a line chart with weekly data that gets updated every week with an additional data point.
    I have used an offset formula to ensure that the line chart gets updated dynamically, which means that I simply have to press update on the chart, for the new data point to be included, however, I would like to only show the value of the latest data point in the chart. Currently, I just remove the data point from the previous week, but since I have 8 series included in each chart and about 40 charts to update, this becomes quite a time consuming task.

    Is there a way to make the chart only show the latest value automatically whenever it gets updated?

    NB! I know of the method where you create additional columns and have them only show the latest value and then adding another series to the chart, so that that value automatically gets updated. However, since the chart is dynamic, I would need to create offset formulas for each one, which also means double up on the number of series (which is already at 320), and then link this to the chart, which would in and of itself be very time consuming. I would like to use this as my last resort, if no other option is possible.

    Thank you in advance.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions

    Re: Dynamically show latest value in line chart

    if your data is oriented in a vertical maner (which is usually the case - single parameter in one column) use your offset formulas with 4th parameter set to 1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If it's not enough, think of using a tip from a yellow banner above first post.

    As for refreshing charts it depends a bit on a way you add the data to your data pool.
    If the charts do not refresh automatically, one can force their refreshment by VBA code based on an event of adding new data. but again such code depends on data layout (and mechanism by which new data is updated)
    Best Regards,


+ 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] How to create line chart with bar chart combo to show for deviation
    By method90 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-16-2019, 11:05 AM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. Change the range in x axis dynamically for line chart
    By dimwit in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2013, 05:23 AM
  4. Line chart doesn't drawo latest value point
    By Enterlen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2013, 05:51 AM
  5. Replies: 6
    Last Post: 07-09-2012, 02:17 PM
  6. 2010 Line Chart Show Zero Value Line
    By erock24 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2011, 08:54 PM
  7. Show line conditionally - Line Chart
    By idrisb59 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-20-2008, 12:45 PM

Tags for this Thread


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