• 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.

Chart: move values from bottom to top (dynamically)

J

jswd

New Member
Hi All,


Does Somebody know how to move the numbers in a chart from the bottom to the top (without respect the X and Y values) in a dynamic way?

Below an image with the first chart (current status) and the next chart with the objetive to have:

http://i44.tinypic.com/316rt6g.jpg


Thanks
 
Sure thing. We can do it by moving the 3rd series to the secondary axis, and then reversing the values on that axis. However, the max value on the secondary axis won't necessarily align with the primary axis. We can either set it manually, or to be trully dynamic, we need to add a dummy series. Dummy series of data is created using the Formula

=MAX(SeriesOne,SeriesTwo)

Format the dummy series to have no lines or markers.


This will find the largest value being plotted on primary axis, and cause the secondary axis to adjust to the same max. You may need to adjust the min to 0, depending on your data.


Visually, there is no "need" to have the secondary axis on the chart, although it may make it easier to understand the image.
 
You must log in or register to reply here.
Back
Top