Beautiful Work Excel Graph Limit Line
In your graph double-click the target line.
Excel graph limit line. Click on Add Target to Chart and it will prompt you to name. So if there are bars on the same chart the horizontal line will not extend to cover the entire first and last bars. First of all select the data table and insert a column chart.
Seems easy enough but often the result is less than ideal. Easy to Use Add Target Line Feature on QI Macros Chart Menu. A data models share of the address space might run up to 500 700 megabytes MB but could be less if other data.
The Add Target Line to Chart tool is on the far left. Maximum limits of memory storage and file size for Data Model workbooks. Add a new data series to your chart by doing one of the following.
This will select the line and open the Format Data Series pane on the right side of your Excel window. In the Format Axis dialog box click Axis Options and then do one or more of the following. But if i enter my limits as -2 to 2 that chart should show up a flat line in the chart at -2 and 2.
As a result my graph ends up being a line scunched up at the top of the graph with little definition on the Y-axis. On the Format tab click Vertical Value Axis in the dropdown list and then click Format Pane. A common task is to add a horizontal line to an Excel chart.
Change chart type box will open. For example say -2 to 2 is my limits. On the View menu click Print Layout.