excel pivot chart with primary and secondary axis 2010

The solution is to create a second Y axis (Y is the vertical axis for any newcomers reading). As a result of this mismatch in data the Excel chart fails to fit the data correctly and it makes the number of units sold impossible to read, the line just looks flat at the bottom of the chart if you can see it! The flaw with this chart is that units sold are in multiples of ten whereas the income is in multiples of thousands. One of the key problems with trying to do this is when your values have very different ranges.įor example, if you want to display the number of units sold and the income made from those sales on one chart you might find that the two data series (units sold and income) end up looking something like this on your Excel chart: If you are creating an Excel report that contains charts, and especially if you are creating an Excel dashboard where space is at a premium, then displaying two unique sets of information is extremely useful.

To learn how to create a chart with two Y axis in Excel read on…. Here are some screenshots showing how you could do this.Adding a second Y axis to an Excel chart can help you display more information on a single chart and empower your users to make better business decisions. Of couse first you need to insert the Funfun add-in from Insert - My add-ins. If you are satisfied with the result you achieved in the online editor, you could easily load the result into you Excel using the URL above. You could check the detailed code of this example on the link below.Įdit: The content on the previous link has been changed so I posted a In this example, with the help of the Funfun add-in, I used HighChart.js to plot this chart.įunfun also has an online editor in which you could test your JavaScript code with you data. This is also a combination of line chart and bar chart for different datasets. You could see in this chart you have one axis of Rainfall at the left side while two axis of Temperature and Sea-pressure level at the right side. Here I made an example using Funfun in Excel. Here I propose to use the Funfun Excel add-in which allows you to use JavaScript directly in Excel so you could plot chart like you've showed easily in Excel. It is actually very easy to plot multi-axis chart using JavaScript with the help of 3rd party libraries like HighChart.js or D3.js.

The picture you showd in the question is actually a chart made using JavaScript.

Excel pivot chart with primary and secondary axis 2010