How do I solve this stupid chart?
Ok guys here's the deal, I basically have 3 rows/colums:
X axis - Hour
Y axis - Volume
Y - 2 axis - Price
Now here's my request, I know how to have two Y axis problem is I don't know how to separate them.
Basically they kind of overlap each other when I don't want them and it is necessary for me that both axis are on the same table but separate.
I basically attached a picture and I want to copy it, SB for the solution
Is this what you're looking for?
Right click on the secondary data series, and then select plot series on secondary axis.
Right click on the data points you want in the right y-axis -> format series -> series options -> secondary axis
I think thats what you wanted.
^No dude you got it all wrong,I've already done that. This is what it looks like. http://imgur.com/Zcw9mND Basically I want to separate the red and blue because they overlap each other.
Does it have something to do with your chart type?
But seems like you're not using Stacked Columns. Hmm.
Okay. This is my first edit:
Found it:
Sorry if I explain in words it may be difficult to follow.
Not the easiest way to overcome the hurdle, but... it works.
Good luck! Let me know if your problem is solved.
Great job,totally what I was looking for.I am completely amazed on how to solve this problem - when I think about it no solution came even close to this one.
thanks!
Edit: The solution works but I'm a complete idiot because it's pretty much impossible to copy the graph from my first post.
Aut deserunt culpa rerum officia modi ut. Commodi ea quam dicta in sequi. Numquam nostrum accusamus omnis nesciunt illo.
Maxime voluptatum consequatur ipsa et. Eaque corporis consectetur libero eum eveniet repellat fugiat.
Delectus et beatae et aspernatur consectetur id. Ut esse aut sint aliquid omnis consequatur itaque. Fugit sunt temporibus dolorem iusto.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...