kasceforms.blogg.se - How to change axes of a scatter chart in excel 2007

#How to change axes of a scatter chart in excel 2007 how to#

So why do you need to use a scatter chart for log/log data? Because it is the only type of chart that allows numeric values along the X axis. You should note that this solution will work for many types of charts, but won't work for charts where you need to plot zero or negative values. If, for some strange reason, values along the X axis are still not represented in logarithmic scale, you can click on the X axis, choose to format it, and then specify a logarithmic scale.

Select the sub-chart type you want to use.

Excel displays a palette of available chart types. Change the axis titles to fit your chart, and you’re all set. Pick both Primary Horizontal and Primary Vertical.

Click the Change Chart Type tool in the Type group. As a final adjustment, add the axis titles to the chart.

(This tab is only available if you select the chart area, as instructed in step 1.)

Make sure the Chart Design (Design in earlier versions of Excel) tab of the ribbon is visible.

To specify a chart where you can use logarithmic scales on both axes, follow these steps: First, right-click on either of the axes in the chart and click ‘Select Data’ from the options.

There’s a better way than that where you don’t need to change any values.

#How to change axes of a scatter chart in excel 2007 how to#

It seems that Excel will not allow the X axis to use a logarithmic scale for many types of charts. If you don’t know how to switch the axes, you would’ve deleted the chart and copy-pasted the contents of columns B and C to exchange the values. The answer to this conundrum is to change which type of chart you use for your data. For some types of data, you may want to create a chart that is not readily apparent. Excel is great at automatically creating a wide variety of charts, lickety split.