This allows someone to chart a value but show the audience that the value might be within a range of numbers that are either greater or less than that value. What is an Error Bar you might be thinking? It is used in statistics to indicate the margin of error for a given value. What we will be adding to the plotted dot is an Error Bar. So how do we turn a single dot on a Scatter Plot into a vertical bar with no dot? Now is time for the creative part! You can hardcode your Y value to zero if you’d like (no cell reference) or link it up to a cell reference to visually show the full coordinates in the spreadsheet. In this example, since our first forecast month is April, the X value will equal 3.5. In this case, you will want the Y value = 0 and your X value to be halfway between the two bars you wish the vertical line to reside. You can then begin to link your X and Y coordinates for your series. With this assumption in mind, I’ll forgo walking you through how to create a chart in Excel.įor this example, we’ll use the below chart to start with and we will work to insert a vertical line to separate the Actual months from the Forecast months. I’m going to assume you already have your chart created and you are looking to add the vertical line to the pre-existing chart. Now if that explanation went way over your head, don’t worry! I will walk you through each step and show you it’s really not that difficult to set this up. We will then turn on vertical Error Bars (margin of error indicators), repurposing them to visually display a vertical line on the chart. The single point charted on the Scatter Plot will control the location of the vertical line. The technique we’ll be using incorporates a single-pointed Scatter Plot (x,y) in combination with your current chart. If you are looking for a more automated/long-term solution for incorporating a vertical line into your chart, this is going to be the solution for you. Creating A Dynamic Vertical Line In Your Chart
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |