From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Area chart: Up vs. down?

Area chart: Up vs. down? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Area chart: Up vs. down?

“

- [Narrator] You ready to make a graph? All right. Here we have enrollments. "Course1" in January had 70 enrollments and then by June it had 122. Now we look down at the total's row. And then in January total enrollments for all seven courses, 650 by June 747. Overall enrollment is going up, but we want to know are there courses where the trend is decreasing? And we would like to do that with a visual. The goal is to create a 100 percent stacked area chart. Don't include that totals row in the chart. Ensure that the months are on the X-axis, not the courses and then name the chart enrollments and then use the visual to identify any courses that are actually trending downward while overall enrollments are trending upwards. Got it? Pause the video, make the chart make the observations, come back. I'll go through it. (funky music) Right. Let's dive in. The cursor is in the data set.…

Contents