4,228 reputation
11131
bio website beavercreekfire.org
location Beavercreek, Ohio
age 44
visits member for 2 years, 11 months
seen 4 hours ago

I'm a fire chief looking to use some of the huge amounts of data we collect/report to help make better decisions for service delivery.


1d
answered Excel Graph with 2 X-Axis Non-Linear Mapping
2d
comment Schedule; want to check if everyone is present
Can you post a screen shot or link to a file sharing account to provide an example? Your description is difficult to understand without the context of the worksheet.
2d
comment Schedule; want to check if everyone is present
Please provide more detail about your specifics. The short answer is yes, it can be done. But the "how" will require more info.
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
Jan
21
reviewed Close How do I create VBA code to extract certain columns of data from excel file?
Jan
21
reviewed Close unique count of values in a cell separated by comma in excel