Here let me show you a smart way to create a target line using error bars This creates a chart, where all the values that exceed the target are highlighted in a different color (you can check this by changing the target value).In the Series Option section, change Series Overlap value to 100%.Select any of the bars for ‘Above Target’ values and right click and select Format Data Series.Go to Insert –> Charts –> Clustered Column Chart.Now we need to plot these values in a cluster chart If the value is lower than the target value, it shows #N/A.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |