PTS Blog

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the whole blog has been helpful, support further development by treating me to a cup of coffee.


Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

CNet Expert on Excel

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.


John Walkenback pointed me to The Digital Home Video: What’s up with Microsoft Excel? in his post What’s Up With Don Reisinger? Despite John’s warning, I watched the video. It was unprofessionally produced, the announcer (Don Reisinger) was ill-prepared, and he whined about all kinds of topics, like the puppy he’s getting, his honeymoon, and how inflexible are Excel charts. Well, if you’re reading my blog, you know that Excel charts are nothing if not flexible, and anyone making a video for a supposedly technically savvy portal as CNET should at least know how to figure out a few tricks on their own.

Rather than flame on, I’ll reproduce the comment I left under the video:Well, I sure got a good first impression of the Digital Home Video. Not very professional, but I guess it does say “Home” in the title. Did you plan what you were going to say first, or did you just have 5:00 to kill? Taking your puppy on your honeymoon, d00d?

You seem to have much more trouble with Excel and charts than someone who talks about technology. Hmm, select data, go to the Insert tab, click on a chart type, and out pops a chart. Sure, the defaults are ugly, but they’re marginally better in the latest version (2007) than before. Sure, the charting interface in 2007 is more cumbersome than before, but it’s somewhat serviceable.

And like any other object in every Office application, and a lot of non-Microsoft applications, you can right-click to find a context menu of options for changing whatever you’ve clicked on. 2007 makes it harder, because in earlier versions you could also double click to bring up a formatting dialog directly, but you can still get to the dialog through the right-click menu.

One of the strengths of Excel is how infinitely flexible the charts are. You can combine different types and apply lots of formatting to achieve effects that other packages wish they had. If you encountered any inflexibility, I’d suspect it’s a case of PEBKAC, or maybe PEBCAK. Watching the video only reinforces this diagnosis.

Possibly Related Posts:

Bookmark and share this entry:
  • Digg
  • del.icio.us
  • Facebook
  • Technorati
  • TwitThis
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • LinkedIn
  • Yahoo! Buzz

Learn how to create Excel dashboards.

Comments


Comment from Tim Mayes
Time: Thursday, September 4, 2008, 2:34 pm

Ha! Great comment. PEBKAC is one of my all-time favorite acronyms. For those who don’t know: Problem Exists Between Keyboard and Chair. :-)


Comment from Simon
Time: Thursday, September 4, 2008, 5:56 pm

You saved me 5:00 Jon thanks.
Comment seems fair, its clowns like that that got us in this ribbon mess (allegedly)


Comment from Chaitanya Sagar, Excel Expert
Time: Monday, April 20, 2009, 8:39 am

Yes. Charts on 2007 definitely seem a bit cumbersome and a little less flexible as well. I had personally enjoyed working on previous charts because if you knew how to make your charts look good, then that will be a differentiators because most other charts looked like those default ones. From Excel 2007, average charts would look lot better.

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.