However, as you can see, we still must switch the Axis Title Names as these have not updated. 4. Updating Axis Titles Double click on the Axis Title and change the name to the appropriate title that represents the values on that axis. Final Graph after Swap The final result shows the ...
Let’s take the example of the same chart we created in the previous section (where the quantities are shown on the Y-axis and sales values are shown on the X-axis): Now, if you want to display Sales values on the Y-axis and Quantity values on the X-axis, you need to switch the...
To position the line to the value you want to highlight, right-click on the line and select"Format Data Series."In the"Format Data Series"pane, switch to the"Series Options"tab and select"Secondary Axis." Step 4 Input the value you want to highlight and the line will move to that p...
Excel does notauto-update the Axis rangesunless the data source is in atable format. So, if you’ve added information, here’s how youchange the X-Axis range. NOTE:When you update the X-Axis Range, you also need to add the Y-Axis. On your Excel Chart, right-click on theX-Axisan...
Go to: Chart Design > Switch Row/ Column. Both columns are displayed on one axis. Method 4 – Changing the Chart Type to Reverse the X and the Y Axis Steps: Click the chart. Select Change Chart Type in Chart Design. In All Charts, click Bar. Choose a chart option. Here, the first...
SelectSwitch Row/Columnand click onOK. You will get the following line graph. Skip this step if you don’t need to organize your line graph. Step 4 – Adding a Secondary Axis to the Graph Double-click on the line graph for Item 3. TheFormat Data Seriespane will appear on the right....
Especially for large data sets, an Excel chart or graph gets to the heart of your findings in a way that is easy to see and understand at a single glance, especially when you incorporate comparisons. If your data has more than one finding to communicate — such as a comparison or if yo...
Legal Notices|Online Privacy Policy Share this page Link copied Was this page helpful? Yes, thanksNot really Change region Copyright © 2025 Adobe. All rights reserved. Privacy Terms of Use Cookie preferences Do not sell or share my personal information ...
How to Select Data for a Chart in Excel How to Set X and Y Axis for a Chart in Excel How to Switch X and Y Axis for a Chart in Excel How to Select Data for a Chart in Excel on Mac How to Select Data in Different Columns for an Excel Chart Free Alternative Office Suite -...
The standard graph doesn't allow for effective comparison of data with differing scales. The solution is to create a separate vertical axis for percentages, scaling from 0% to 4.5%. A secondary axis works best for a combo chart, so we switch the defect percentage data series to a line, ...