I am able to draw simple, colored lines on a chart, but when I move the
chart, as I do every week to accomodate new data on the page, the lines stay
where they were originally drawn. In other words, the lines seem attached to
the undelying worksheet, not to the chart itself. Is there a way to draw
lines that are attached to the chart?

Thanks in advance for any help.

Manxman:

To attach a line to a chart, first select the chart. you know it's selected
when solid squares show up on edge of chart box.

Now you can draw your line and Excel will place in chart.

If you don't select chart first, Excel places on worksheet, not chart.

I have simple tutorials that show you how to add vertical, horizontal lines
that can be updated and will automatically adjust as your data changes. You
may want to check this post.

http://processtrends.com/pg_charts_horizontal_line.htm

Kelly

(E-Mail Removed)


"manxman" <(E-Mail Removed)> wrote in message
news:0B225DC8-D63E-49CD-AC01-(E-Mail Removed)...
>I am able to draw simple, colored lines on a chart, but when I move the
> chart, as I do every week to accomodate new data on the page, the lines
> stay
> where they were originally drawn. In other words, the lines seem attached
> to
> the undelying worksheet, not to the chart itself. Is there a way to draw
> lines that are attached to the chart?
>
> Thanks in advance for any help.

I love it when it's simple. Thank you Kelley. Your website looks great, but
what I'm doing here is simply adding a handdrawn colored line, the eqivilent
of a note.

"Kelly O'Day" wrote:

> Manxman:
>
> To attach a line to a chart, first select the chart. you know it's selected
> when solid squares show up on edge of chart box.
>
> Now you can draw your line and Excel will place in chart.
>
> If you don't select chart first, Excel places on worksheet, not chart.
>
> I have simple tutorials that show you how to add vertical, horizontal lines
> that can be updated and will automatically adjust as your data changes. You
> may want to check this post.
>
> http://processtrends.com/pg_charts_horizontal_line.htm
>
> Kelly
>
> (E-Mail Removed)
>
>
> "manxman" <(E-Mail Removed)> wrote in message
> news:0B225DC8-D63E-49CD-AC01-(E-Mail Removed)...
> >I am able to draw simple, colored lines on a chart, but when I move the
> > chart, as I do every week to accomodate new data on the page, the lines
> > stay
> > where they were originally drawn. In other words, the lines seem attached
> > to
> > the undelying worksheet, not to the chart itself. Is there a way to draw
> > lines that are attached to the chart?
> >
> > Thanks in advance for any help.
>
>
>

Hi Kelly,

I am having the same issue - but I am not able to complete the Horizontal
Line.

I set the data up as you stated in your tutorial - in my case I have a month
worth of data showing daily population on the chart. I want a horizontal line
that states that the Maximum # of inmates to be 513 - when I put in the
Horizontal Line data and follow your instructions it only puts in 2 days
worth of data at 513?

What am I doing wrong?

Thanks

"Kelly O'Day" wrote:

> Manxman:
>
> To attach a line to a chart, first select the chart. you know it's selected
> when solid squares show up on edge of chart box.
>
> Now you can draw your line and Excel will place in chart.
>
> If you don't select chart first, Excel places on worksheet, not chart.
>
> I have simple tutorials that show you how to add vertical, horizontal lines
> that can be updated and will automatically adjust as your data changes. You
> may want to check this post.
>
> http://processtrends.com/pg_charts_horizontal_line.htm
>
> Kelly
>
> (E-Mail Removed)
>
>
> "manxman" <(E-Mail Removed)> wrote in message
> news:0B225DC8-D63E-49CD-AC01-(E-Mail Removed)...
> >I am able to draw simple, colored lines on a chart, but when I move the
> > chart, as I do every week to accomodate new data on the page, the lines
> > stay
> > where they were originally drawn. In other words, the lines seem attached
> > to
> > the undelying worksheet, not to the chart itself. Is there a way to draw
> > lines that are attached to the chart?
> >
> > Thanks in advance for any help.
>
>
>

Hi,

Sounds like you are not using a xy scatter chart so only the first 2
categories are being filled.

Depending on the rest of your data you can do one of the following;

- change chart type to xy-scatter
- change axis type to Time Series
- use the max value for each of the data points you already have

Cheers
Andy

Gladys wrote:
> Hi Kelly,
>
> I am having the same issue - but I am not able to complete the Horizontal
> Line.
>
> I set the data up as you stated in your tutorial - in my case I have a month
> worth of data showing daily population on the chart. I want a horizontal line
> that states that the Maximum # of inmates to be 513 - when I put in the
> Horizontal Line data and follow your instructions it only puts in 2 days
> worth of data at 513?
>
> What am I doing wrong?
>
> Thanks
>
> "Kelly O'Day" wrote:
>
>
>>Manxman:
>>
>>To attach a line to a chart, first select the chart. you know it's selected
>>when solid squares show up on edge of chart box.
>>
>>Now you can draw your line and Excel will place in chart.
>>
>>If you don't select chart first, Excel places on worksheet, not chart.
>>
>>I have simple tutorials that show you how to add vertical, horizontal lines
>>that can be updated and will automatically adjust as your data changes. You
>>may want to check this post.
>>
>>http://processtrends.com/pg_charts_horizontal_line.htm
>>
>>Kelly
>>
>>(E-Mail Removed)
>>
>>
>>"manxman" <(E-Mail Removed)> wrote in message
>>news:0B225DC8-D63E-49CD-AC01-(E-Mail Removed)...
>>
>>>I am able to draw simple, colored lines on a chart, but when I move the
>>>chart, as I do every week to accomodate new data on the page, the lines
>>>stay
>>>where they were originally drawn. In other words, the lines seem attached
>>>to
>>>the undelying worksheet, not to the chart itself. Is there a way to draw
>>>lines that are attached to the chart?
>>>
>>>Thanks in advance for any help.
>>
>>
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Gladys:

if you send me your workbook, I'll set up the horizontal line.

be sure to correct my anti-spam e-mail address be removing extra characters.

(E-Mail Removed)**remove_these**



...Kelly

"Gladys" <(E-Mail Removed)> wrote in message
news2FDC5F3-6658-465D-A96C-(E-Mail Removed)...
> Hi Kelly,
>
> I am having the same issue - but I am not able to complete the Horizontal
> Line.
>
> I set the data up as you stated in your tutorial - in my case I have a
> month
> worth of data showing daily population on the chart. I want a horizontal
> line
> that states that the Maximum # of inmates to be 513 - when I put in the
> Horizontal Line data and follow your instructions it only puts in 2 days
> worth of data at 513?
>
> What am I doing wrong?
>
> Thanks
>
> "Kelly O'Day" wrote:
>
>> Manxman:
>>
>> To attach a line to a chart, first select the chart. you know it's
>> selected
>> when solid squares show up on edge of chart box.
>>
>> Now you can draw your line and Excel will place in chart.
>>
>> If you don't select chart first, Excel places on worksheet, not chart.
>>
>> I have simple tutorials that show you how to add vertical, horizontal
>> lines
>> that can be updated and will automatically adjust as your data changes.
>> You
>> may want to check this post.
>>
>> http://processtrends.com/pg_charts_horizontal_line.htm
>>
>> Kelly
>>
>> (E-Mail Removed)
>>
>>
>> "manxman" <(E-Mail Removed)> wrote in message
>> news:0B225DC8-D63E-49CD-AC01-(E-Mail Removed)...
>> >I am able to draw simple, colored lines on a chart, but when I move the
>> > chart, as I do every week to accomodate new data on the page, the lines
>> > stay
>> > where they were originally drawn. In other words, the lines seem
>> > attached
>> > to
>> > the undelying worksheet, not to the chart itself. Is there a way to
>> > draw
>> > lines that are attached to the chart?
>> >
>> > Thanks in advance for any help.
>>
>>
>>