News

Excel defaults to a linear scale for graphs, but you can easily change it to logarithmic to suit wide data ranges or logarithmic phenomena. The Chart Wizard produces graphs with linear scales.
When data is plotted as a chart, it can be done using two types of scales—arithmetic or semi-logarithmic.
There is disagreement on the proper way to label logarithmic scales in charts and graphs, especially when the base is not 10. This post shows several alternative ways of labeling log scales ...
Description I'm developing a mixed chart (line chart + area chart) with 2 y-axis labels for data viz purposes and I need to apply a logarithmic scale on the second y-axis. The issue comes when I use ...
A logarithmic price scale is a type of scale used on a chart that depicts two equivalent price changes by the same vertical distance on the scale.
Creating a semi-log graph in Excel follows a similar procedure, but with a few key differences. To create a semi-log graph, you’ll need to select the “Logarithmic scale for Y-axis” option when ...
To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.
When data is plotted as a chart, it can be done using two types of scales—arithmetic or semi-logarithmic. The difference in scale can completely alter the shape of the chart even though it is plotted ...