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.
Error ut facere labore et libero deleniti suscipit. Ad consequatur incidunt beatae aspernatur aut. Facilis alias et provident expedita. Nam eligendi ipsum asperiores.
Voluptate dicta est voluptas minima hic. Ea sed placeat et quas. Sunt rerum voluptas omnis quas dolore quam.
Quia error labore consequatur mollitia aliquam aspernatur. Quia sed distinctio at sunt. Est ea molestiae voluptatem doloremque.
Quo adipisci adipisci ut minus quibusdam. Molestias praesentium hic et nihil fugiat a rerum neque. Et vel quis voluptatem quo qui quam.
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...