How to insert a row in Excel using keyboard shortcuts...

There really should be a direct keyboard shortcut just for this...

Jonathan, on February 22nd, 2007 at 11:39 am Said:
Insert a new row…
1 - Shift Space to select the row
2 - Control + to insert a new row
Delete a row
1 - Shift Space to select the row
2 - Control - to remove row

or even better
Alt+Enter to avoid having to use the shortcut key (after selecting a row)

Quick directions for getting IIS up and running

I always forget the right permissions to set. Wizard included with IIS makes it easy. Instructions here.

Finally figured out how to do a cluster/stacked column chart in Excel 2007

I got confused about the instructions here.
I couldn't figure out at a high level what the steps were about. Now that I better understand what's going on, here's the conceptual idea of what's going on:

• We first select a dummy table of data that contains only the labels we want to use on the horizontal axis. All values are 0 so this can be shown on the graph without actually changing the view of the data we really want to see.


• We then copy in all the data we really want to use. Map that data to be plotted on a secondary axis. We want the secondary axis for this info since the tick marks for secondary data always show by default at the top of the chart (you can change this, but it doesn't quite line up).


• We also change the overlap of each data bar to be 0 so we get the look we're going for.


• Explicitly ask for the Secondary Axis to be shown so that it behaves as we expect.
  


• Adjust the selected data so that the first blank row of data is used (for spacing purposes).


• Go to the HORIZONTAL axis options dialog and change the secondary VERTICAL access to appear Low (that is to the left, stupidest UI I've ever seen...). Vice versa for the primary vertical axis.
  


• Hide the appropriate tick marks and data labels for the axis we're not using.

Here are the semi-step by step instructions:
1. Select the small table of data you want to use for the blank horizontal axis and create a Stacked Column Chart from that data (see example file here).

2. Now select the real data you want to use and paste in the data into the chart we just created.

3. Select one of the data bars that has real data, and then right click. Select Format Data Series...

4.Change Gap Width to be 0%. Choose to Plot Series On: Secondary Axis. Click OK.

5. Do this for the rest of all the "real" data bars (you will only have to the Plot part).

6. Go to Chart Tools, Layout, Axes, Secondary Horizontal Axis, Show Left to Right Axis. Now things should be looking better (real axis on the bottom, fake one on top).

7. Right click again on one of the real data series. Choose Select Data...

8. Click each of the Legend Series can contains real data (not the dummy one) and edit the "Series name" so that it doesn't include the first blank row. Also adjust the "Series values" to INCLUDE the first blank line. Do this for all of your columns of data.

9. Go to Chart Tools, Layout, Axes, Primary Horizontal Axis, More Primary Horizontal Axis Options.

10. Change the "Vertical axis crosses:" to be "At maximum category". This switches the primary axis to be to the right.

11. Go to Chart Tools, Layout, Axes, Secondary Horizontal Axis, More Secondary Horizontal Axis Options.

12. Change the "Vertical axis crosses:" to be "Automatic". This switches the secondary axis to be to the left.

13. Turn off all unneeded tick marks and labels by changing them to None in the appropriate More Axis Options dialogs.

14. Turn on/off the appropriate horizontal gridelines.

15. Delete the dummy series from the legend.

16. Yikes! That was waaay harder than it should have been.

Wow...

Great webpage on secondary axises in Excel

I finally understand what a secondary axis is and how some of the hacks work.

Dr. James Watson - when genetics loses its soul

An interesting set of comments the co-discoverer of DNA has made over the years.

Another recap/fact check on Inconvenient Truth

Washington Post fact check

Drive space hierarchical tools

http://www.nytimes.com/2007/10/11/technology/circuits/11askk-003.html?em&ex=1193371200&en=dd7e5992516f2324&ei=5087%0A

Article from NY Times on possible tools.

Named and dynamic ranges in Excel

Sooo exactly what I needed...go Excel...did I just say that?
http://www.cpearson.com/excel/named.htm

Autism Video Glossary

Great resource. Requires setting up a username. Quick video experience kinda stinks, but great stuff.
http://www.autismspeaks.org/

Why is it so hard to find screenshot utilities for cell phones?

Kinda a basic thing...for any UI designer that is.

Couldn't get FExplorer 1.7 to install on my test Nokia N75. Finally found this for my old Treo 700w:
http://www.iliumsoft.com/site/fp/screen_capture.php

Phew!
Bob

Judge's ruling on Gore's Inconvenient Truth - where he exaggerated

http://blog.washingtonpost.com/fact-checker/2007/10/an_inconvenient_truth_for_al_g.html

Tutorials on how to create a combined cluster stacked column chart in Excel

Links to tutorials:
http://www.peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Nice quick library to concatenate two queries in CF

Code found here.

Article on how to parse 2 buttons using CF

easycfm tutorial on this

Techie explanation of EAR and WAR files

Still only kinda get it...but good enough for now...
Here

Nice guide for setting up IIS on windows XP

Here it is

SJ Mercury News article on CEA and EQ coverage

http://www.mercurynews.com/pattyfisher/ci_6850326