Fine Beautiful Graph With Two X Axis
Follow these steps to create a chart like this in PowerPoint 2007 or 2010.
Graph with two x axis. Double-press with left mouse button on left y-axis values to open the. I get two values per feature. You need to change the original data in the First method including sorting and merging cells.
And a pivot table need to be created based on your data then create a Column Chart based on Pivot table. I want to create chart in powerbi. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group.
There are 2 X axis value Date and one Y axis value amount. Select Secondary Axis for the data series you want to show. Here is how to add a secondary axis.
Only one Y axis but on the right side of the graph. I have seen that a secondary axis is supported by Combo charts but not for the chart I need it for. Using two axes in the one chart.
In the Charts group click on the Column button and. Select Combo Cluster Column - Line on Secondary Axis. Double-press with left mouse button on one of the two data series in the chart to open the task pane.
Select Design Change Chart Type. On one set the origin of the graph to be the upper right To do this double-click on either axis and go to the Frame and Origin tab of the Format Graph dialog. Two Y axes with different lengths or colors.