Some styles work better for smaller graphs, and some styles work better for larger graphs. You’ll need to try a few different dashed styles. Experiment with a Few Different Dashed Styles Right-click on that dot and select Outline. You would click on the dot in this screenshot, for example, to edit just the section of line to the left of it. The dot controls the piece of the line just before it. If you click on one of the dots a second time, then you can edit one smaller segment of the line at a time. For example, you can change the line’s color, width, etc. You can edit the entire line at once, just as you normally do. If you click once on the line, you’ll notice that all of the dots are selected. How do you get the dotted line appearance? This part is really easy! Click Once to Edit the Entire Line How to Change Solid Lines to Dotted Lines in ExcelĪfter setting up your table, you’re going to insert a line graph just like you’ve done a million times before. By default, Excel gives you a solid line. I want to focus on the numbers that we do have data for. I don’t want every single year’s label to show up in the graph. In the table, you’ll notice that these placeholder values don’t have fiscal years above them. Selective Labeling Will Focus Your Audience on Your Years of Choice Increase Each Year by the Placeholder Value Why 11? Because there’s an 11-year gap between FY07 and FY18. To find the placeholder value, I took the FY18 number minus the FY07 number and divided that by 11. In this example, we’ll make our line increase by 5.27% each year. You need to fill in some placeholder numbers with estimated values. So how did I do this? How to Add Placeholder Data to Your Table Dotted lines are great for visualizing estimates or uncertainty. We used a dotted line to connect two points on the graph.
Nothing.Īnd, there’s all this white space between FY07 and FY17, which is obviously not going to work.
0 kommentar(er)
