How can I change the color of certain gridlines "not" all gridlines? For
example, with a control chart - a yellow line for mu - 2sigma and a blue line
for mu - 1sigma?
How can I change the color of certain gridlines "not" all gridlines? For
example, with a control chart - a yellow line for mu - 2sigma and a blue line
for mu - 1sigma?
Jones:
Rather than change grid line color, add a horizontal line at the value you
want.
I have an example control chart at this link.
http://processtrends.com/pg_charts_control_chart.htm
I explain how to add a horizontal line here.
http://processtrends.com/pg_charts_horizontal_line.htm
....Kelly
[email protected]
"jones7288" <[email protected]> wrote in message
news:[email protected]...
> How can I change the color of certain gridlines "not" all gridlines? For
> example, with a control chart - a yellow line for mu - 2sigma and a blue
> line
> for mu - 1sigma?
>
>
Hi,
You can not format individual gridlines. The work around is to add extra
data series for draw the line. Here is a collection of examples to
help you.
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm
Cheers
Andy
jones7288 wrote:
> How can I change the color of certain gridlines "not" all gridlines? For
> example, with a control chart - a yellow line for mu - 2sigma and a blue line
> for mu - 1sigma?
>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks