Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help with the graph to not end in zero

    Hi,
    I am not able to make graph not to end in zero.
    Graph attached

    Thank you for help
    Roman
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,643
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Roman,

    Consider this workbook that eliminates the need for a second table on sheet 2 and unsightly #N/A's (false) needed to filter rows and hide series in the graph. The end of each series concludes with its last value instead of a zero and the graphs between fuel providers and the years are controlled by the checkboxes at the graph bottom. Also, the coding is smoother with less choppy screen updates.

    HTH,
    Maud

    Roman1.png
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jul 2016
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    HI,
    That is great.
    It looks much butter now.

    Thank you very much

    Roman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •