![]() So keep those out of there, most of the time. Ultimately we've got a total here that's almost 8,000, and yet we've got some numbers here that are not even 200, so we're going to have extremely high columns and very small ones at the same time. Now, we could do this, and I'll show you a little bit later what that looks like, but imagine some of these totals appearing here. As a general rule, but certainly not an iron-clad rule, do not mix totals and details together. ![]() These will appear in charts as they did in the prior example. How about a chart with this data? I didn't say it earlier but do, when you're selecting data for a chart, highlight the row that's typically above it, also the column that's usually on the left side for descriptors, labels. Now, I'm going to delete this chart simply by pressing "delete". The most common chart type for most Excel users tends to be a chart of this type. Alt + F1 always shows what's called a Clustered Column chart. So, we've created a chart here with one method, alt + F1. It's a lot simpler, it's been redesigned from prior versions starting in Excel 2013, so, still, one of the problems you will encounter as you work with charts sometimes is, you've just got way too many choices. The Format tab is a lot about the visuals. The Design tab is more important, for the most part. There's a Design tab, there's a Format tab. We've got a new ribbon called Chart Tools. Notice also, the menu system has changed. That might or might not be the best chart. You'll get a chart immediately, right on the same worksheet. If you want a chart quickly, the data's highlighted, press alt + F1. If you say Graph, I have a good idea you mean Chart, but Chart is the term we look for and we use in the Excel menu system. Now in Excel, officially and formally, we use the word Chart, not Graph. Let's imagine we'd like to display a chart to accompany this data. ![]() Some of us don't absorb the numbers as easily as others. We can see the numbers, we know what's happening, and yet, a picture can really help. ![]() We're looking at a worksheet called Creating Charts in the file 07 - Charting. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |