• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charts - Multiple Series Axis

P

patsfan

Member
Guys, I am replicating Chandoo's dynamic chart with check boxes and have a question. With his chart, it is fairly simple to overlay 3 different series when the values are within the same range. However, My chart would have Sales up to $100,000 and I want to overlay a line graph using percentages (usually between 15%-25%). My question would be... can I create this overlay with the sales $ axis on the left and the % axis on the right?
 
Should be able to just put the line graph on the secondary axis. It depends somewhat on what dynamic settings you are using. Could you provide a link to the exact dynamic chart you are using of Chandoo's (or the article link)? That would help give us a better understanding of your situation.

thanks
 
Hi Patsfan


Here is a dashboard I created, it has a few charts on all with multiple axis if it is of any help to you:


https://docs.google.com/file/d/0ByiZqUlQMjxhYXdRS20zeHdXSDg/edit?usp=sharing


I've hidden the values of the secondary axis on the charts as I use it as markers selectable by drop down boxes or check boxes
 
I cannot determine where I received the file but it was from Chandoo, either from an email or a tip I pulled from here "Dynamic-Chart-with-check-boxes" was the name. Corporate IT security is also preventing me access to those data-sharing sites. I guess in simpler terms, is it possible to create one chart with two different series where each series uses a different number format? Example, series with dollar values on the left, and a series with percentage values on the right. OR do I need to create two separate charts and overlay to look like a single chart (if possible)?
 
You must log in or register to reply here.
Back
Top