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. Created in Excel, the line was physically drawn on the graph with the Shape Illustrator. In the Edit Series dialog, enter a name for your data series (I chose reference) and select the X values you entered from Step 2. In Select Data Source dialog, click the Add button. The dotted line serves as a visual cue to differentiate actual from forecast. Add a new data series by right-clicking the graph and choosing Select Data: 4. 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. ArchivesCategories |