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

Jun
18
comment Plotting multiple datasets of different lengths on the same scatter graph in Excel 2010 (extended)
just pick the largest length and use that. If a particular series isn't the same length it just won't plot anything for the empty cells.
Jun
18
comment Seeing email thread in email body on ipad, but not on pc
does he have the conversations feature turned on in Outlook?
Jun
1
comment Forcing axis units in Excel 2013 plots, being written after minimum bound of axis
@Mr.Mascaro: I agree, with a caveat, that it depends on the story you are trying to tell, and how you tell it. You should not change the axis to be misleading, but the axis range can be used to highlight min and max vaiues.
May
7
comment Calculate date average in excel
This will give you the average month, and the average day of the month. It will not, however, return the average month/day of the year.
May
7
comment Rule to dim cells
If you are changing the color, why not use the built-in Conditional Formatting feature in Excel? Regardless, you'll need to share some code if you want anyone to help.
May
5
comment Excel 2013 - Multiple Countifs
@miltonb if you know of a way to have a pivot table do this, please post it as an answer.
Apr
28
comment Excel Charting - How to edit the X axes for positive value on both sides?
Short answer, anything you want to show to the left of the axis you have to change to a negative value (even if it is positive), then use custom number formatting in the axis to show positive instead of negative left of the 0 value of the axis.
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
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
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
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
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.
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
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?