C
Carl Witthoft
The documentation on this is pretty weak, so I thought I'd drop off this
hint. If there's a better/faster way, please feel free to correct me.
The problem: how to display two different types of graphs in one chart.
My personal case involved displaying a bar-chart histogram with a
scatterplot of the analytic distribution function. Here's what I did.
First, paste both sets of data into a new chart. Then select one set of
data and right-click (or select Format Item...), and tell excel to use a
secondary value axis. Once that's done, you can click on Chart Options
and specify a secondary category axis as well.
Now comes the part that was unintuitive, at least to me. Click on one
of the data series. Select ChartType, and pick the type you want (in my
case, either column data for the histogram, or scatterplot for the
"real" data). That type selection will only apply to the selected data
series, leaving the other series and its associated axes as-is.
Once done with all this pain, be sure to save the chart as a Custom
Type.
cute, eh?
hint. If there's a better/faster way, please feel free to correct me.
The problem: how to display two different types of graphs in one chart.
My personal case involved displaying a bar-chart histogram with a
scatterplot of the analytic distribution function. Here's what I did.
First, paste both sets of data into a new chart. Then select one set of
data and right-click (or select Format Item...), and tell excel to use a
secondary value axis. Once that's done, you can click on Chart Options
and specify a secondary category axis as well.
Now comes the part that was unintuitive, at least to me. Click on one
of the data series. Select ChartType, and pick the type you want (in my
case, either column data for the histogram, or scatterplot for the
"real" data). That type selection will only apply to the selected data
series, leaving the other series and its associated axes as-is.
Once done with all this pain, be sure to save the chart as a Custom
Type.
cute, eh?