![]() ![]() ![]() In this tutorial, we will go over each of the above cases one by one and show you how to remove dotted lines in Excel (or dashed lines). You might also just be seeing light colored spreadsheet gridlines that seem to look like dotted lines.Someone might have put dotted borders around cells in your sheet.It may be signaling a page break or you may be in page break view.It may be because areas of your sheet were selected as ‘ Print Areas’.Here are some common reasons you might be seeing dotted lines on your Excel worksheet: But in order to remove them, you need to first diagnose why you are seeing them (or where they’re coming from). It can sometimes be quite a source of annoyance. ![]() There may be a number of reasons you see dotted (or dashed) lines on your Excel screen. Whatever the case, we will try to tackle it step by step so as to help you find the solution. While this approach might suffice as a quick method for achieving the desired effect it isn’t ideal for recurring use of the graph, particularly if the line’s position on the x-axis might change in future iterations.The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line. Created in Excel, the line was physically drawn on the graph with the Shape Illustrator. Note: If you want add other texts to the existing print area, simply select them and click. Just click Set Print Area and you are done. ![]() Then, find Page Layout tab, click Print Area in Page Setup section. First, select all texts you want to set as the print area. The dotted line serves as a visual cue to differentiate actual from forecast. Here I’ d like to share the tip of setting and clearing the print area in Excel. The data is units of output over time where the first nine months of the series are actual data and the remaining four months of the year are a forecast. The following chart illustrates what Dave describes. If there were a way to embed it in the data or somehow format the chart, that'd be awesome.” “Do you know of a trick for drawing vertical lines to delineate years (or actuals/historical vs forecast/future segments of the chart)? I currently have to draw them with the line drawing tool, which gets messy when moving the chart on a PPT slide. Today's post is a step-by-step Excel “how-to” inspired by a reader question we received following a recent post on using dotted lines in data visualizations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |