Reputation
4,258
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 12 32
Newest
 Nice Answer
Impact
~593k people reached

Apr
13
awarded  Nice Answer
Apr
8
comment Excel: Get rid of gaps in line chart
I would absolutely add the data point markers, then use a lighter shaded line to help emphasize the difference between actual data (your points) and interpolation (your lines).
Apr
6
revised Excel Graph with 2 X-Axis Non-Linear Mapping
additional image based upon example
Apr
4
awarded  Yearling
Mar
31
answered Excel Graph with 2 X-Axis Non-Linear Mapping
Mar
27
comment setting upper and lower limit excel histogram
One minor point for your consideration, Column Charts are not Histograms. There are several distinct differences between the two types (although they do look similar).
Feb
27
comment Filtering values on Excel Pivot Chart
I would build this into your SQL query (e.g. add a where value < x statement)-then Excel doesn't have to filter anything. Is there a reason that wouldn't work?
Feb
27
answered Export excel chart to png with certain dimensions
Feb
24
comment How do I use fill color for negative values in spider chart?
It's only necessary to define minimum and maximum if you want the bi-color scheme. If the simple red circle would suffice (or the colored red center only), then you only need to define your "break-over" value as a series. This series could be static or dynamic and could change across categories if needed. If this value will always be 0, you could also use a formatted major gridline and not need the additional series.
Feb
23
revised How do I use fill color for negative values in spider chart?
incorporated comment
Feb
23
comment How can I move an Excel Table to a different worksheet?
Thanks, but I need to move the tables on the worksheet-not the worksheet itself. Any thoughts on that?
Feb
23
revised How do I use fill color for negative values in spider chart?
Added image
Feb
23
answered How do I use fill color for negative values in spider chart?
Feb
18
comment graphing the temperature curve of my wood fired oven in excel 2003
@fixer1234, as best I can tell, this is the answer-you should post it as one.
Feb
9
comment Generate event distribution chart in Excel
@KrzysztofWolny can you ask a new question, referencing this one, that details your problem? Troubleshooting through these comments will be too difficult.
Jan
22
reviewed Close What is I/O? How does it affect PC operation?
Jan
22
reviewed Close match product and copy a row range to Sheet 2
Jan
22
reviewed Leave Open Assistance with Excel macros
Jan
21
reviewed Approve Keyboard shortcut to switch between sheets in Excel
Jan
21
reviewed Close Excel: extracting a number from mixed content cell