How to create a stacked bar chart in Excel

How to create a stacked bar chart in Excel

My boss’ management is clamoring for metrics. They want to know, at a glance, what we’re doing and how far along we are. Sounds like a job for stacked bar charts in Excel to me. So here’s how to create a stacked bar chart in Excel.

Figuring out a way to track our progress was fairly easy. Figuring out how to make Excel display that chart in a meaningful fashion… Well, that took about five hours. I’ll try to make it easier for you than it was for me.
Read more

How to take apart Hot Wheels without a drill

How to take apart Hot Wheels without a drill

I get the question all the time how to take apart Hot Wheels without a drill. This trick doesn’t work on older cars with metal bases. But you can indeed take apart newer cars with plastic bases without drilling the rivet. The trick is to use a soldering iron to heat up the rivet and the plastic base enough to let you take it apart. So here’s how to open a Hot Wheels car with a soldering iron.

Read more

Testors model paint tips for better results

Testors is a brand that’s been around for decades. It’s by far the most common brand of model paint for hobbyists. Here are my Testors model paint tips to reduce frustration, give you better results, and save you money. After all, a hobby should be enjoyable, not frustrating.

Read more

Restoring Tootsietoys and other early diecast vehicles

Restoring Tootsietoys and other early diecast vehicles

Restoring Tootsietoys can be a fun and satisfying way to enjoy old toy vehicles. Whether you want your childhood toys to look nice again or just enjoy bringing new life to neglected examples, it can be as easy and as affordable as you want it to be.

I’ll talk specifically about Tootsietoys here, but the principles apply to other vintage diecast cars of the same era like Hubley or Midgetoy.

Read more

True 1:48 O scale cars (as in autos)

True 1:48 O scale cars (as in autos)

Scale-oriented O scale enthusiasts often bemoan the lack of true 1:48 O scale cars (as in automobiles) to go with their O scale trains. Often they go so far as to call 1:48 scale autos non-existent. That’s not entirely the case. There are 1:48 scale vehicles out there. Finding them just requires some creativity and imagination.

I know of more than 20 1:48 scale vehicles suitable for O scale train layouts. They fall into two broad categories: ready made diecast vehicles, and plastic 1/48 scale model car kits, which require assembly. The model kits tend to be costlier but allow a greater level of detail. Not only that, some of the model kits are 4-door sedans, the perfect ordinary car. For the realism-craving hi rail or 2-rail enthusiast, they are hard to resist.

Read more

What scale are Matchbox cars?

What scale are Matchbox cars?

What scale are Matchbox cars, you ask? Unfortunately it varies a bit. Nominally they’re around 1:64 scale. But scale isn’t Matchbox’s objective. Fitting in the package is. That means the size of Matchbox cars is between 2.5 and 3 inches, depending on what looks right for the prototype model. So it can take some homework to figure out the actual scale of any given model.

Read more

WordPress Appliance - Powered by TurnKey Linux