Reputation
815
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 14
Newest
 Yearling
Impact
~119k people reached

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)
Mar
19
answered Excel 2013 - Is there a way to turn off a chart series without removing it
Feb
23
comment Excel pivot and chart - hiding field from the chart
you can get away from the concatenation by "Repeating All Label Items" in the Report Layout section of the pivot table design tab of the ribbon. That way you would add the date and project, and they would display like a normal table (each row containing each label)
Feb
23
comment Consolidate Text Data in Excel
start learning pivot tables, great resource for quick calculations.
Feb
23
comment Excel - How to create a stacked radar chart?
@user1542743 To get it to connect from 8 to 1, you just need to repeat the numbers from Stat8 in the Stat1 column on the corresponding rows.
Feb
23
comment Is there a software or web service that allows the creation of basic flow charts from text (such as a numbered or bulleted list)?
You can do this (to some extant) in Word by inserting SmartArt.
Feb
23
comment How could I set a Text Highlight Color—not cell shading—for a specific text within an Excel cell?
@omareg94 you'll see in the screenshot that Excel provides no option to highlight the text, only to change font color, or make sub- or super-script.
Feb
21
answered How do I Calculate Variance with Missing Values coded as -99?
Feb
20
comment Excel 2013 spreadsheet is too slow
A few things. You are running XP. No longer supported and likely not tuned to work with Excel 2013. Are you running the 64-bit version of Excel 2013? That could cause issues as XP doesn't support 64-bit anything. You got a new hard drive: fewer RPM? More RPM and not compatible with XP? Does anyone else have the same issues with the file? Especially with a similar software setup?
Feb
19
awarded  Organizer
Feb
19
revised Mirror column on separate sheet in Excel 2010
mirroring tag not appropriate here
Feb
19
suggested approved edit on Mirror column on separate sheet in Excel 2010
Feb
11
comment How do I format a MAC address to be separated by colons?
If you need a second opinion, no you cannot do this with a format mask. Format masks work great with numbers, but don't work with text.
Jan
29
comment Placement of Secondary Horizontal Axis
That was it Jon. Didn't think to check the vertical axis properties. Thanks!
Jan
29
accepted Placement of Secondary Horizontal Axis
Jan
28
answered How do I use the corresponding number to make the selection in a dropdown instead of using the mouse?