![]() ![]() This is easy, a line simply connects two points, right? It should span the chart, starting at X = 0 and ending at X = 6. Let’s say we want a horizontal line at Y = 2.5. Add a Horizontal Line to an XY Scatter ChartĪn XY Scatter chart is the easiest case. The examples below show how to make combination charts, where an XY-Scatter-type series is added as a horizontal line to another type of chart. ![]() And sometimes they just seem to move whenever they feel like it. Since they are independent of the chart’s data, they may not move when the data changes. Since they are drawn freehand (or free-mouse), they aren’t positioned accurately. We won’t even talk about trying to draw lines using the items on the Shapes menu. This tutorial shows how to add horizontal lines to several common types of Excel chart. Seems easy enough, but often the result is less than ideal. ![]() The horizontal line may reference some target value or limit, and adding the horizontal line makes it easy to see where values are above and below this reference value. A common task is to add a horizontal line to an Excel chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |