+ Reply to Thread
Results 1 to 3 of 3

Help on a "simple" line Graph - 3 data points min/avg/max flat line 3 markers

  1. #1
    Registered User
    Join Date
    08-09-2023
    Location
    London, England
    MS-Off Ver
    Office 16
    Posts
    4

    Question Help on a "simple" line Graph - 3 data points min/avg/max flat line 3 markers

    Hi all,

    Would really appreciate if anyone knows how to do this as been trying for a while but having no luck..

    After a simple line graph I can throw into a powerpoint rather than manually making and taking hours (lots of data points to use).

    Something that looks like the below:

    I-------I---------I
    min avg max

    where the avg line will move in line with the difference between min/max..

    Any help would be amazing !

    Thanks,
    RM

  2. #2
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Help on a "simple" line Graph - 3 data points min/avg/max flat line 3 markers

    HI
    Look at the formulas in columns C and D.
    Insert values ​​into the graph and edit as Scatterplot.
    HI,
    Mario
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-09-2023
    Location
    London, England
    MS-Off Ver
    Office 16
    Posts
    4

    Re: Help on a "simple" line Graph - 3 data points min/avg/max flat line 3 markers

    This is helpful, thank you !

+ 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. Data Labels only on "Line Ends" on Excel line graph
    By NewEnglandMade in forum Excel General
    Replies: 3
    Last Post: 06-11-2023, 07:57 PM
  2. Replies: 4
    Last Post: 09-19-2019, 10:54 AM
  3. Macro that removes Line Markers in Line Graph
    By gaffler7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2012, 02:00 PM
  4. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  5. Replies: 2
    Last Post: 10-06-2007, 01:26 PM
  6. Replies: 2
    Last Post: 08-02-2006, 11:10 AM
  7. [SOLVED] How do I "index" data in a line graph?
    By ShirleyJL in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2005, 07:06 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