How to draw static vertical lines in Excel graph
I have a set of values SLA for various category & would like to draw a static horizontal line for the SLA
eg
Sev 1 - 89, 90, 94
Sev 2 - 50, 90, 90
Sev 3 - 40, 94, 40
These are the SLA for Sev1, Sev2, Sev3 in various month, however the SLA is constant for Sev 1 as 90, sev2 as 95 & sev3 as 98 which i want to represent via horizontal line while capturing the values via bar graph.
I am unable to draw a vertical line.
Kindly help
Your question is confusing in the sense you keep on mixing horizontal and vertical terms.
Maybe post a workbook with you current chart and use autoshapes to draw the lines you want represented in the chart.
This page links to a few tutorials which should be able to help:
http://peltiertech.com/Excel/Charts/AddLine.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks