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.
Thanks to Everyone Who Attended Today's Excel Webcast! ... as well as Tips and More Information
I hope everyone enjoyed today's event and found it useful. As promised, I'm posting a few links here as well as steps for the PowerPoint tip I wasn't able to show ...
Links\Resources
Sizing Excel Charts for Word - article with downloadable sample files
Microsoft Tools for Your Job - a large assortment of articles, templates and tools specifically for the things you do in your particular job, every day
Microsoft At Work - lots of great original content, and content collected from around Microsoft.com, for topics from getting started in new programs to better ways to get your work done
Office Online Training - tons of free, self-paced, easy-to-follow courses on a wide variety of topics and a variety of levels, for all Office programs
Steps for Importing an Excel Chart into PowerPoint
This is super fast, easy, and fun, and I will demonstrate it next Thursday during my PowerPoint webcast as well.
Note: If you don't want to create your own Excel chart to try this, use the Excel sample file available for download at the bottom of the Sizing Excel Charts for Word article linked above.
Start with your Excel chart on its own sheet in Excel, and then:
1 - In PowerPoint, create a chart slide and double-click to open the chart (that takes you into Microsoft Graph)
2 - On the edit menu, click Import File. The dialog box that opens will enable you to browse to the file that contains your Excel chart. Select your file and click Open.
3 - In the Import Data Options dialog box that opens, select the sheet name containing the chart you want to import and click OK. Your chart, with most of its customization in tact and even any drawing objects you had placed on the chart (such as arrows or text boxes) will appear as a fully functional MS Graph chart -- the data will automatically import right along with it).
That's all there is to it! But ... here are a few notes on this topic to keep in mind:
- You can also import just data for a chart if you like, by selecting a data sheet instead of a chart sheet in the Import Options. If you select a data sheet rather than a chart sheet, you'll see options to select either a specific range or the entire sheet.
- If you want your imported chart to take on the colors of your PowerPoint presentation, just close the chart and return to the PowerPoint slide -- then double-click on the chart again to edit it -- this will automatically update the colors.
- Note that a few chart types that can combine in Excel can't in Microsoft Graph. So, for example -- the Column\Scatter combination that I used for the Price Volume demonstration today would not import entirely into PowerPoint -- a scatter and a column chart can't combine. Most chart types that are commonly used however, will import perfectly into PowerPoint, exactly as they appear in Excel.
Happy Thursday everyone!
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt2/mt-tb.cgi/76
