Reputation
795
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 14
Newest
 Organizer
Impact
~89k people reached

Apr
17
revised How to give worksheet tab a color if range of cells contains text
inappropriate use of macro tag
Apr
17
revised How to export images from Excel table
replaced macro tag with vba
Apr
17
suggested approved edit on How to give worksheet tab a color if range of cells contains text
Apr
17
suggested approved edit on Excel, macro move one row down and then delete the row
Apr
17
suggested approved edit on How to export images from Excel table
Apr
15
comment Calculate total number of open item at each month in Powerpivot
I think that would assume that there is a close date entered. Although absent any other information from the OP, who knows?!
Apr
9
revised What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015?
Removed inappropriate tags
Apr
9
comment making a running total for excel using countif function, 1 out of 14 drop down options don't work
Can you provide the formulas you are trying? Also some data can help so that we can see what the answer should be.
Apr
9
answered Excel 2011 plotting difference between logged sent-time / acknowledgment-time
Apr
9
suggested approved edit on What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015?
Apr
7
comment How can I make a Scattered chart in excel where the dots are different colors?
I've got an idea, but a question for you first, how many importance levels are there? Will that number ever change?
Apr
7
comment Excel: Get rid of gaps in line chart
There really isn't a way to do this outside of what you've already described. On another note, I'd caution against this, as connecting the dots (so to speak) can infer that there is data that doesn't really exist, and can be misleading.
Mar
30
revised Different colored columns in excel
clarified the type of chart needed.
Mar
30
answered Different colored columns in excel
Mar
26
comment Weird Calculated Field behavior in a Pivot table in Excel
By "Number of items in your pivot table" you mean distinct number of items? Which for purposes of your data above, the Grand Average would equal 3.5? (7 line items/2 distinct items in Day column)
Mar
25
comment Weird Calculated Field behavior in a Pivot table in Excel
hmmm... I would suggest that you change your question to include what you are ultimately trying to do. You may find that the way you are approaching this intermediary step could be improved/changed to better suit your end goal.
Mar
25
answered Weird Calculated Field behavior in a Pivot table in Excel
Mar
25
answered Display excel grid lines in front of a chart?
Mar
24
comment How to plot IP address frequency distribution chart on Excel or Calc?
Using a pivot table would also provide you with a unique list of candidates, and the count of each, which could then be graphed.
Mar
23
answered Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)