Would You Approve This Excel Book Cover?

There is a list of Excel books on my Contextures website, and it hasn’t been updated recently. Today, I checked Amazon, to see what new and exciting Excel books had been released, so I could start adding them to the list.

New Excel Book

There’s a book – Excel 2010 Made Simple, by Abbott Katz — with a release date of May 31, 2011, from Apress, the publisher of my pivot table books.

Amazon lists the book as “not yet released”, but they show the cover, which you can see below.

Excel Book Cover wtih 3-D chart
Excel Book Cover wtih 3-D chart

Excel Charts Chapter

One of the chapters is on Excel charts, and the book blurb promises that you’ll learn “How to create colorful, meaningful charts”.

I hope the cover chart was selected by someone in the Apress marketing department, and not the author!

Missing Books

I’ll be updating the list of Excel books over the next few weeks, so if you know of any recent books that are missing from the list, please let me know, so I can include them. Thanks!

Make a Simple Pie Chart

And if you do need to make a pie chart in Excel, for a business report, or for the cover of your next book, keep it simple!

This video shows how to make a basic pie chart in Excel, then add formatting, labels, and other features. Use your Excel charting powers for good, not evil!

Excel Chart Links

If you want to learn more about Excel chart, but not the 3-D rainbow-coloured kind, check out the tutorials at the following links:

Box Plot Chart (Box and Whisker)

Line-Column Chart 2 Axes

Cluster Stack Chart

Pie Charts

Waterfall Chart

In-Cell Charts

____________

33 thoughts on “Would You Approve This Excel Book Cover?”

  1. Ouch. Doesn’t Apres give the author the chance to review the book cover? Our author team certainly influenced the cover art on the RibbonX book. While I’m not going to say it was brilliant, it ended up miles better than the first pitch.

    Personally, this cover art would stop me from buying the book as it obviously doesn’t represent good charting displays…

  2. No, the chart in te cover would be flashy but for someone who has experience is useless.
    I would no buy it, if no know you as writter.

  3. Ken,

    Visually appealing covers and catchy titles get interested buyers to pick up books and look inside. The conversion rate jumps exponentially. While I think authors should exert some influence on the cover, the ultimate goal is to sell, right? Authors should focus on what’s between the covers, not what’s on them. That should be left to the marketing experts.

    And while Excel experts like you or data visualazation gurus probably are not likely to buy the book based on this cover, are Excel experts and data visualatization gurus really the target audience? My guess is that the target audience is more beginner/intermediate users of Excel. A 3D shadowed pie chart may not be very useful (or even possible per JP), but visually, it looks cool and it may entice a potential buyer to investigate further. Mission accomplished.

  4. Jason –

    While it is true that sizzle sells the steak, there are two problems with this cover. First, the unknowing buyer picks up the book, then is upset that he can’t find how to make the chart on the cover. Second, someone with a little knowledge of effective data visualization techniques who wants to learn about Excel will take one look and pass this one by. I guess if the former outweigh the latter, that’s fine, because the buyer who is upset about not learning how to make atrocious charts has already paid for the book.

  5. I wouldn’t buy it, and I probably wouldn’t even take it off the shelf to look inside. That “chart” looks more like “Excel Made Stupid”.

  6. Jason,

    I agree that the cover should be visually appealing, and that it helps sell the book, yes. But I’m not in the camp that any advertising is good advertising. There are loads of examples out there of great looking, functional and effective charts on the web. Jon and Chandoo’s sites are two that immediately jump to mind as repositories.

    Flash and sizzle is absolutely important, as a book is often being judged by it’s cover (as we’re doing now.) But so is the credibility of the author amongst both the purchasing audience and his/her peers. (The peers are very often people who recommend the book to potential customers.)

    My feeling is that Marketing people are there to market, but often lack the deeper knowledge of the subject matter expert. It is up to that person to pull the marketing people back and tell them (in this case) “I like your idea, but could we use a more effective chart type so it doesn’t compromise my standards?” I’ve been sold bills of goods in the past, and it’s not a good feeling. As Jon points out, you can’t even build the featured chart in Excel. That may not have been an issue in the past, but with the full feedback systems we have now, you risk a 1 star review on Amazon.

    To be clear, I haven’t read the book, and don’t know the author. I even hope the book sells well for him. This is meerly meant as constructive criticism of the choice of artwork by whomever decided.

  7. Let me ask a dumb question. Are you sure you can’t build a chart like that in 2010 (I don’t have 2010) with some creative VBA? I’m guessing the designer didn’t use any native 3D charts in Excel because none them were visually stimulating.

    Great discussion.

  8. Visually stimulating or not, one should not use 3d charts, period. With any luck, a future added protocol to the Geneva Convention will list them as “crimes against data.”

  9. “Crimes against data”! Beautiful!

    Jason, haven’t tried. I avoid both 3D and pie charts unless mandated to use them by my bosses boss. And even then I argue vehemently.

    From a technical point, I don’t believe that you can build them, as Excel separates wedges rather than stacks them up, but you never know. Maybe you could do it by creative use of an area chart. Regardless, even if you could, you shouldn’t. 😉

  10. A stacked, 3D, pie chart in stair step format could be very informative if it used color fading.
    The color fade would illustrate the rate at which each pie segment’s value was accumulated.
    I knew there had to be a use for the additional colors available in xl2007 & 2010.

  11. Jason –

    VBA doesn’t let you make charts you couldn’t do manually. The wedges in a 3D pie chart all have to be the same. I guess you could build something with several different charts, each chart having only one visible wedge, but that’s a lot of time to waste to make a totally useless graphic.

  12. Maybe the marketing guys were just using the Homer Simpson strategy. “Ummmm, PIE !!!”

    Excel Made Simpson.

  13. “You can’t even make a chart like that in Excel, fortunately.”

    Oh I wish that were true Jon. Whilst not a chart it is Smart Art!

  14. Patrick M,

    Agreed on 3D charts…not very practical from a business sense (I would never use them). But if it helps sell the book, then use it, right? I don’t think Ken and I will ever agree though on this one. 😉

  15. Insert a basic pie from the cycle daigram section.
    Apply one of the 3d styles, birds-eye for instance.
    Select a slice.
    Via format dialog…
    3-d rotation > Distance from ground.
    3-d format > Bottom > Height
    Repeat for other slices.

  16. […] Would You Approve This Excel Book Cover? […]

  17. Funnily enough, a printer did something similar to me.
    I wanted a couple of nicely printed and bound workbooks to be able to see the sort of quality I could get, and show them to a potential client.
    The course I used as an example was my Advanced Excel Charts course, as it had plenty of graphical content (as you might expect) as well as text.
    In order to make it look “better” the printer took it upon themselves to take my minimalist cover (company logo + course title basically) and jazz it up with some pictures of “fancy” charts, no doubt googled up from some horrid BI marketing pages.
    3D charts, gradient fills, black backgrounds, dials and gauges, every dreadful thing you could think of and totally against all the principles taught in my courses.

    I didn’t dare show it to my client, and luckily got the job anyway, but needless to say, I was fuming!

  18. Debra I have not seen so many comments on a subject in a long time that is in reference not to Excel, but to a book on Excel and even then on the cover no less. This author must right now be OMG!
    Note it reads – Excel 2010 Made Simple is for newcomers to Excel.
    Then again it was noted that the author – “has a doctorate in sociology and wide-ranging writing experience as well. Abbott has composed, and continue to compose, numerous complex spreadsheets, twinning technical fluency with the imagination to realize Excel’s potential in a diverse array of settings.”
    I think the last couple of words set the stage – “the imagination to realize Excel’s potential in a diverse array of settings.”
    Do we have a word from the author on the subject matter – hello out there you can come out now.

Leave a Reply to Morton Wakeland Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.