+ Reply to Thread
Results 1 to 3 of 3

How stop graphic descend

  1. 11-22-2019, 05:34 AM #1
    vasc
    vasc is offline
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    How stop graphic descend

    Hi my friends...

    In my graph cell aa297 is last with data
    how learn excel to let line horizontaly to value 279
    Now line get down to 0


    any ideea pls...
    Attached Files Attached Files
    Last edited by vasc; 11-22-2019 at 06:12 AM.
    Reply With QuoteRegister To Reply
  2. 11-22-2019, 10:03 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How stop graphic descend

    One of the options could be to use series based on such modified values:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    and changing card type to scatterplot

    Other will be by creating dynamic graph using only filled cells for series
    See for instance https://peltiertech.com/Excel/Charts...umnChart1.html
    It's shown on column type graph, but the same technique could be used for line graph.
    Attached Files Attached Files
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 11-22-2019, 10:09 AM #3
    vasc
    vasc is offline
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: How stop graphic descend

    Briliant my friends..
    thanks

    Solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How Do I Make a Same Color Pie Chart that gets Lighter as the amounts descend
    By Xcelerator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2017, 10:18 AM
  2. VBA - Tick/untick the direct, 1 stop, 2+ stop checkboxes within Skyscanner
    By fatboy1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2017, 03:54 AM
  3. Click Button to start/stop a Stop Watch
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2016, 01:25 PM
  4. How can I stop the short menu appearing when I press the full stop key?
    By Sadieberg in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-06-2015, 07:43 AM
  5. Stop Screenlock or Stop ShutDown through an Excel File
    By ag273n in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2014, 08:42 PM
  6. Graphic X=cte
    By alfred33 in forum Excel General
    Replies: 2
    Last Post: 10-14-2006, 07:32 PM
  7. SUBTOTAL formulas stop working correctly when new data is added. How do I stop this?
    By fbarbie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2005, 05:49 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1