• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

fixed vertical axis line graph - values plot incorrectly

cjw

New Member
Having problem getting fixed primary vertical axis to properly display values for all 3 data series below. I got around this by assigning snow depth data series - green line - to secondary axis.
However, I need to actually plot temperature values on a secondary axis, so this solution won't work...
Any suggestions on how to adjust primary vertical axis? file is attached, tab 2.
Thanks for sharing any tips on how to fix this...

upload_2014-3-5_10-48-45.png

upload_2014-3-5_10-48-10.png
 

Attachments

  • USGS_SNOTEL.xlsx
    91.3 KB · Views: 6
Hi ,

The issue is that you have selected a stacked line chart instead of a normal line chart ; is this intentional ?

Narayan
 
N
Hi ,

The issue is that you have selected a stacked line chart instead of a normal line chart ; is this intentional ?

Narayan, you are brilliant - this was exactly the problem. Selected the normal line chart and - (DOH!) - my vertical axis display problem was solved. Thanks so much for your speedy reply - really appreciate you taking the time to correct such a stupid mistake.
 
Back
Top