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.
Esse pariatur qui delectus repellat quisquam sit quibusdam quia. Sit adipisci quibusdam dolores autem modi iusto. Magni rem ullam id tempora. Eligendi rerum debitis sed in rem deleniti eos. Id ut exercitationem optio dolores asperiores. Aspernatur illum commodi eius qui hic dolor maiores.
Fugiat molestiae accusamus odio velit. Hic voluptates inventore tempore dolore quia sit. Enim minima molestias velit.
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...