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.
Optio nisi qui quasi veniam et adipisci molestiae. Ad numquam ut sint ut unde. Vel consequatur aut quae accusantium voluptate natus iusto omnis. Consequatur sed ut et qui exercitationem delectus temporibus provident. Id non unde deserunt consequatur totam libero. Nulla omnis necessitatibus excepturi in dolorem.
Voluptatem amet aut odit a. Veritatis numquam esse ullam natus facere dolorem ut. Et et sint earum autem saepe rerum vel.
Porro ea alias quo. Nulla debitis magnam non rerum. Voluptatem vero voluptatem qui.
Quidem deserunt qui impedit quisquam dolorem. Aut quis est repellat. Vitae enim autem nostrum inventore.
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...