TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)

Please be sure to mention the version of Office you are using when you send your question.

I answer all e-mails that I receive via this form, as long as they are polite :)

Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.

Hi, everyone! Thanks to those of you (and there were quite a lot of you!) who took the time to attend today's Excel chart tips and tricks session. As promised, following are some links to resources for more help and information ...

For a review of any charting basics ... creating and formatting charts -- there is an excellent series of short and easy-to-follow courses available free at Office Online Training:
Charts I: How to create a chart
Charts II: Choose the right chart type
Charts III: Create a professional-looking chart

For the step-by-step help I promised for sizing Excel charts for Word:

Sizing Excel Charts for Word

And, related to that - to learn about using tables to create page layouts in Word, check out my course Tables II at Office Online Training.

For the steps to create a Price Volume chart, as well as other advanced chart types such as bubble charts, check out this advanced chart tips webcast that I gave in January:

Advanced Tips and Tricks for Excel Charting: Financial Pitch Books Made Simple (Level 300)

For more help with the part of price volume charts that requires getting the exact end date on the chart's X-axis, here's an earlier blog post that will walk you through it:

Show the Data's Exact End Date on a Line Chart X-Axis

And, slightly off-topic, but still on charting ... check out a recent article for Microsoft At Work: Take Your Data Traveling: Using Charts and Diagrams in Multiple Programs ... that's another resource on sizing Excel charts for Word -- as well as how to import Excel charts into PowerPoint and how to create a Visio organization chart from Excel data (which I'll also demonstrate in next Tuesday's PowerPoint\Visio webcast).

For more charting and other document production tips ...

If you have my book, Microsoft Office Document Designer (MODD), and you have installed the tools on the MODD CD, you have a set of 75 tip sheets and articles accessible from the MODD toolbars in Word, Excel, or PowerPoint, with step-by-step instructions as well as tips and tricks covering a wide range of document production -- including much of what we covered today as well as both more basic and more advanced charting tips.... along with lots of document and chart samples.

And, for great Excel tips from a couple of Excel MVPs -- I can't say enough good things about these two guys:

Curt Frye, Excel genius, is the author of several Excel books. Find tips and tools and lots of fun stuff on his site: http://thatexcelguy.com/

Jon Peltier is a scientist and also an Excel genius. He takes a very different approach to charting than I do, being a scientist, rather than a presentation person like myself ... for a different perspective and lots of great tips and charting tutorials, check him out:http://peltiertech.com/

If you need resources for anything I didn't post here, or have a question that you didn't get a chance to ask in today's session, please post a comment and I'll reply asap.

Meanwhile, happy Thursday!