Reputation
5,362
Next tag badge:
140/400 score
96/80 answers
Badges
3 13 35
Impact
~1.3m people reached

Apr
18
comment How to set a non-linear Y axis on a graph in Word?
I use charts in Word all the time. I've found its easiest to create the chart in Excel then paste special it into Word as an .EMF. If you'll change it frequently (which I also do), you may try and do a linked chart, but I've found they are more trouble than a copy/paste.
Apr
18
awarded  Famous Question
Apr
13
comment Prevent chart with Smooth Lines from exceeding a minimum value
Data charts aren't art-they're supposed to represent the underlying data, not a "pretty" estimation. So, unless the fitted curve matches your data you should stick with your actual data points and lines which are a reasonable estimate of the intervening values.
Apr
13
revised Excel Chart, Formatting Line with Stack Column Chart
additional info
Apr
13
comment Excel macro: replace entire worksheet with different values
Graph automatically update to that chart?
Apr
8
revised Excel Chart, Formatting Line with Stack Column Chart
additional explanation
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
No! Stay away from pivot charts (pivot tables are great-the charts aren't). It's a combination stacked column chart and xy/scatter chart.
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
And, no you shouldn't send data. If anything, post some demo data for others to help you as well. You'll likely get a couple different ways to accomplish what you need, then you can mark the answer that helped you the most/best answered your question.
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
This doesn't include a second axis (per your requirement) but demo's the helper series.
Apr
8
answered Excel Chart, Formatting Line with Stack Column Chart
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
A helper column is simply additional data that you can use to "shape" the chart-in this case add labels and explanatory lines.
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
The quickest/easiest method is to add a "helper" data series to your chart and make a combo chart with the "helper" series as a XY/Scatter plot. Then use that series for your vertical axis labels. Add a final additional point with a horizontal error bar for your horizontal line (detached from the normal grid lines).
Apr
8
comment Excel Chart, Formatting Line with Stack Column Chart
To have a second vertical axis, you need a data series plotted to it. Since you have a stacked chart, presumably your data is all on a single vertical axis? Do you need a second axis, or do you need a label configuration that shows different, but related values?
Apr
8
comment Logarithmic scale in Excel chart with non-transformed axis labels
There's no built-in way that I know of (and I've done a lot of log charting). My experience with Excel is that "hacking" is the best way-I basically consider it part of the user experience. Also, if Jon Peltier has a work-around, a native Excel solution probably doesn't exist.
Apr
6
comment How do I highlight some specific parts of a chart depending on the axis line?
I've included more description for each, but if you have a preference, I can provide more step-by-step instructions for that item.
Apr
6
revised How do I highlight some specific parts of a chart depending on the axis line?
additional description
Apr
6
revised Finding multiple local maxima and placing data labels on corresponding chart
additional commentary
Apr
6
answered Finding multiple local maxima and placing data labels on corresponding chart
Apr
5
answered How do I highlight some specific parts of a chart depending on the axis line?
Apr
4
awarded  Yearling