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.
Et consequuntur quidem consequatur et aut autem laboriosam. Et ullam est cum ratione eum et illum. Quos ea omnis iusto officiis recusandae deserunt autem. Dicta omnis praesentium nemo est illum voluptas.
Enim quam ea eum ducimus. Rerum sint corporis harum nulla inventore. Nemo aut aut aut et cupiditate illum autem. Distinctio itaque nam sit ullam et incidunt.
Quod quas quia sit est. Ipsum et dignissimos reprehenderit non assumenda unde magnam. Fugit exercitationem est dignissimos itaque voluptatem suscipit. Expedita ut sunt eius nobis maxime aliquid veritatis et.
Sapiente adipisci numquam explicabo id totam. Eligendi quia similique aliquam eaque. Possimus sit et possimus. Quo consequatur sapiente optio culpa officia.
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...