[RESOLVED] Excel - combo chart scatter and column!
Anybody know how to make a combo scatter + column chart so the x-values line up?
The fundamental problem is that a column chart behaves like a "line" chart in that the x-axis corresponds to labels instead of values. If the x-values of the scatter plot are linear, everyting lines up nicely, but in that case there is no reason to have a scatter plot in the first place. If the x-values are not linear the plots don't line up (see attached example where I want each column to line up horizontally with the corresponding data point but clearly doesn't).
Is there some trick to make this work or have I encountered an Excel limitation w/o workaround?
My actual situation is more complex, but the attached illustrates the issue. My data is such that I can't use a line plot, must have a scatter plot.
Reply With Quote