March 2013
Intermediate to advanced
304 pages
9h
English
book
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
by Isaac Gottlieb
Content preview from Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 6
Excel Charts
Charts convey much more information than just reading spreadsheet data. Charts make it easier to see what is hiding behind the numbers. In this chapter, you are going to find out how to generate and format Excel charts. I will demonstrate how to use some of the different types of charts and the common techniques to deal with all Excel charts.
QUICK/INSTANT CHART
To get a quick/instant chart from data in Excel, select any cell in the data range as shown in Figure 6.1 (alternatively select the entire range B3:E8) and press the F11 key. When you use the F11 key, it generates a clustered column chart (the default chart) on a new sheet. You will find it on the sheet Simple Chart in the Excel file Chapter 6.
FIGURE 6.1 The F11 Key Creates an Instant Chart
If you wish to change the default chart type after Excel created it, right-click on an empty space inside the chart, and then select Change Chart Type in the local menu. A window with chart options will pop-up and allow you to select a different chart type. See Figure 6.2.
FIGURE 6.2 Right-Click to Change Chart Type
Here is an alternate way to select a different chart type. When you create a chart, Chart Tools appear on the ribbon. This Chart Tools ribbon shows Design, Layout, and Format tabs. Click on the Design ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.