Quote Originally Posted by shg View Post
but for the x axis, it MUST BE a scatter chart. Change the chart type.
Thanks again. As the title of the thread suggests, I'm trying to draw a histogram, not a scatterplot. (Since I'm trying to visualise the distribution of a single variable, not compare two variables, a scatterplot isn't appropriate.)

As Microsoft, in their wisdom, have deemed log transformations of the x axis unneccessary, I suppose a hack is in order. So, it possible to either

1. Hack one of the other chart types to display histograms bars? The scatterplot chart definitely do log-x-scales but can it display bars? The barplot chart type can obviously display bars, but will it allow for a continuous variable on the x-axis?

2. Plot a histogram of the log-transformed variable and override the axis labels with natural scale values, as I first suggested?