Excel 2019: A Beginner's Step by Step Guide to Excel 2019 for Boosting Project Productivity by Adams Dustin

Author:Adams, Dustin [Adams, Dustin]
Language: eng
Format: epub
Published: 2020-06-09T16:00:00+00:00

Creating Visualizations

Now that you know some basic principles in creating visualizations, let’s use our timesheet solution to explore how to generate a simple line graph. The line graph will be a stacked graph that compares total hours worked between the two weeks. Execute the following steps:

Go to sheet “7-8-18~7-21-18”

Select one of the tables

Open the Line Graph Drop down : [ALT]⋙ [N]⋙ [N]⋙ [1]

Select “100% Stacked with Markers”

Delete unneeded lines (all but 2)

Right click one of the lines

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.