Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
You can fill columns, bars, pie slices, chart areas, plot areas, and many other nonlinear chart elements, in other words those elements that encompass boxes or spaces, with built-in and your own created color gradients. Once again, we're talking about the capability of going beyond what you might find in the Format tab in the Ribbon. So, despite all of the choices that we have here, we might want to change colors based on our own needs. So, for example, on the chart on the left, maybe I want to change the chart area color, the outer parameter.
So I'll simply right-click and go immediately to Format Chart Area. And we can use fill here, and perhaps a solid color, lots of choice. Yellow was the last one used by whoever was using this feature last, but we've got all these choices here and certainly others we can get too as well under More Colors. So certainly you can go down that path. Another choice might be Gradient fill. Again, the choice that comes up is one that was used recently. But you can go to preset colors.
Once again, things we didn't know we needed, but if this appeals to you, there it is, and on and on and on with these choices, rainbows of all different hues and shapes, and so on. Don't stop there necessarily. Once you have done those, you can control the direction of them, and I'm not making a strong case for saying this is a great choice here, but we all have our preferences. I would never actually make this choice, but it does show what's there, quite a few built in. You can do the same thing for the plot area. You can do the same thing for the legend. You can do the same kind of thing for the title as well: either Solid fill, which is a little more conservative perhaps, or Gradient fill, as well as pictures and texture fills, which was covered in another movie in this course.
So there are many, many choices here if you're trying to fill in the colors in any part of a chart that encompasses a box, or at least a potential box, as we've see in the example of titles, and legends, chart areas, plot areas, et cetera-- lots of choices here for formatting.
There are currently no FAQs about Excel 2007: Charts in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.