MS Excel: Custom Data Labels

In Microsoft Excel, if you ever needed to graph some data but then attach a data label with it that wasn’t necessarily the data value of that point, there is a way to do that. This also a good way to attach notes to the graphs and can be easily customized.

Let us assume this is your data:

You want to plot the first half of that data like normal:

Next you can right click on each of three bars and select Format Data Series. Now select the Data Labels tab and select Values and press OK.

You should now see the graph like this:

Now since you want to associate the second half of the data values with this bar graph, you select each data value individually – you can do this by click the value once, to select all the values associated with that color:

Then click again to select that point individually:

Now press the “=” key and select the cell the new data value that you would like to show. Repeat this last process for each data point and you will be set to go:

I am pretty sure you can write up a VB script for it and I probably will in due time if necessary, but hopefully this helps for now.

Excel Help Request [Solved]

[Edit] Problem solved, using a SumIF ended up fixing both of my problems. Thanks to Mr. Feraudo. [/Edit]

For you Microsoft Excel experts out there, I have data on the scoring for an individual player and I am trying to figure out the use of a formula or two to calculate the following: I need to calculate the number of goals a person scored at Home (or Away) without individually counting them and then do the same thing for games in which the player’s team Won or Loss.

I thought about using CountIf but I’m not sure how to count items from a range of data based on a criteria that is not necessarily in the range. For example, if I want to count items from the Goals column based upon whether the Location is Home or not. Also, I’m not too familiar with using the Offset formula to calculate a column’s worth of data in a single cell as opposed to repeat it for every cell.

Any suggestions would be greatly appreciated. Even if you think you have something that might work but you aren’t too sure, feel free to shoot me an email or talk to me online about it.


Free Windows 7 Through Stevens & MSDNAA

Here is a step-by-step instructional guide on how to get free and legal copy of Windows 7 from Stevens Institute of Technology. Also, I’m sure you can follow the second half of this once you obtain an account to Microsoft Developer Network Academic Alliance (MSDNAA) from your educational or professional institution.

My good friend Brian Feraudo who told me about this last week and I completed the installation on my new laptop last night. I still have some drivers to download for my finger print reader but for the most part, everything seems to be working perfectly. Although I’m not a big fan of Microsoft using the A-Team music in the background as they use little girls and cartoon-ish animals in their commercials but Windows 7 is definitely a great product worth getting — especially since it’ll be free.

Here are the steps (after the break):

Continue reading “Free Windows 7 Through Stevens & MSDNAA”