 
|
To create a chart in Excel, you can select the data on the worksheet, then use the Ribbon commands to insert the chart. Use the Keyboard Shortcuts If you'd rather use the keyboard to insert a chart, there are a couple of shortcut keys that you can tap. To insert a new sheet [...] I'm working on some pricing reports for a client, and one of the requests was for a Pocket Price Waterfall chart. I hadn't made one of those before, and fortunately the client sent me a sketch of the chart that they wanted. It looked something like this.
The good news was that it [...] My eyes are still burning from this experiment, so read on at your own risk! Last week, you saw this book cover, here on the Contextures blog. I asked if you, as the author, would approve the cover artwork. There were several comments, with most people agreeing that they would have selected a different [...] If you're building a new city, or plotting world domination, you'll need a powerful project management tool, such as Microsoft Project. For smaller projects, you can list your tasks in Excel, and create a Gantt chart, to show the timeline. List the Project TasksIn this example, we're creating the company budget for next year. [...] In Excel 2007, there was a PivotChart Filter Pane, and you had to open that if you wanted to filter the pivot chart. Things have improved in Excel 2010, and the PivotChart Filter Pane is gone. The field names now appear on the pivot chart, which is great news! Each field button has a [...] Last week, someone tweeted a wish for a new Excel Chart type: "It's 2010... come on Excel... all I want for Christmas is a 3d scatter chart, it's not too hard! I don't want to have to fire up Processing!"If you could have one new Excel feature, is that what you'd ask for? [...] We have a very famous waterfall here in Canada, and it creates gorgeous photos, like this one from my fall 2008 vacation.
You can create waterfalls in Excel too -- Waterfall Charts. They might not be as spectacular as Niagara Falls, but can be useful for showing how values change. There are details [...] Remember, Sunday October 17th is Spreadsheet Day, so you'd better start planning your celebrations. You could start the day with a big bowl of Chex cereal -- each bite looks like a little spreadsheet. For dessert at the end of the day, have some pie, or bars, while you dream about charts. As my contribution [...] Earlier this month, I had the pleasure of flying out of Chicago's O'Hare airport. I was checking in at the ungodly hour of 6 AM on a Sunday, and hoped that would be a quiet time at the airport. The streets near the downtown hotel were almost empty, so that was encouraging, but the [...] If you're doing Excel training, or writing blog posts, or creating sample files, you might need to find some public data to use in your Excel file. You don't want to publish confidential client data, even if it's a bit disguised, or reveal your household finances to the world. Instead of creating sample data on [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
