Hi there!
I am trying to compare concentration vs time. I have two sets of concentration data that vary wildly in their maximums so I'm attempting to make two Y axis so I can show both sets accurately. When I created a custom scatter secondary axis plot, it created duplicates of all my series data. So before I had 7 sets of high and 7 sets of low data for a total of 14 data sets. Now I have 28.
I'm not sure what to look for as I saw others have similar issues but due to the cells being formatted. Only my time (x axis values) are formatted and when I cleared their formatting, it didn't change what I wanted.
I've attached a photo showing how my data looks.
If there's more information I can provide, please let me know!
Thank you!
Bookmarks