Adding Additional Points to a Line Chart

I have an existing line chart. Four variables w/ five data points each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data points
(ie, same symbol to represent each variable but not part of the line of the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is embedded
in a PPT presentation so I would prefer not replotting it in Delta Graph.

Thanks!
Christine

Just add each one as a new data series and format to get the required symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta Graph.

Thanks!
Christine

It is a "line with markers" and I'm working in 2007.

I'm sorry if I sound like I don't know what I'm doing, we generally plot 90%
of our stuff in Delta Graph so I'm not sure of the right places to go to get
what I want in Excel.

This graph was supplied by our client as part of a PPT presentation and they
wanted to add the data at the 12th hr when the presentation is due.

I appreciate any guidance!

Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta Graph.

Thanks!
Christine

So I added each as a new data series with the time point designated to keep
them to the right of the existing graph. I then went in and changed the
symbols out to match to the existing data lines.

But now I have two sets of information in the legend. Is there any way to
delete out the second set?

Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta Graph.

Thanks!
Christine

Oops, forgot to ask...

Is there any way I can delete out the horizontal grid lines but keep the x
axis line? I found the gridlines pull down but I can either have the lines
or not...including the x axis.

Thanks,
Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta Graph.

Thanks!
Christine

1) If you carefully select the legend for the point, you can remove it with
Delete key
2) If you click on a gridline so that all are selected (shown by symbols at
each end), you can wish them farewell with the Delete key

What is Delta Graph?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
Oops, forgot to ask...

Is there any way I can delete out the horizontal grid lines but keep the x
axis line? I found the gridlines pull down but I can either have the
lines
or not...including the x axis.

Thanks,
Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required
symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points
each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an
overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta
Graph.

Thanks!
Christine

Thanks!

Got the legend items I wanted to delete but when I select any of the
gridlines that I need to delete, they are ALL chosen including the x axis!

The lines make the graph so much harder to read, I can't understand why they
don't offer an option that just has the x and y axes without the extra lines.

Christine

"Bernard Liengme" wrote:

1) If you carefully select the legend for the point, you can remove it with
Delete key
2) If you click on a gridline so that all are selected (shown by symbols at
each end), you can wish them farewell with the Delete key

What is Delta Graph?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
Oops, forgot to ask...

Is there any way I can delete out the horizontal grid lines but keep the x
axis line? I found the gridlines pull down but I can either have the
lines
or not...including the x axis.

Thanks,
Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required
symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points
each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the data
points
(ie, same symbol to represent each variable but not part of the line of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an
overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta
Graph.

Thanks!
Christine

The gridlines and the axes lines are DIFFERENT things. You can delete
gridlines without changing the axes lines. I wonder if you have an axis with
no line?
Wan to send me a file so I can experiment? Get my email from website
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
Thanks!

Got the legend items I wanted to delete but when I select any of the
gridlines that I need to delete, they are ALL chosen including the x axis!

The lines make the graph so much harder to read, I can't understand why
they
don't offer an option that just has the x and y axes without the extra
lines.

Christine

"Bernard Liengme" wrote:

1) If you carefully select the legend for the point, you can remove it
with
Delete key
2) If you click on a gridline so that all are selected (shown by symbols
at
each end), you can wish them farewell with the Delete key

What is Delta Graph?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
Oops, forgot to ask...

Is there any way I can delete out the horizontal grid lines but keep
the x
axis line? I found the gridlines pull down but I can either have the
lines
or not...including the x axis.

Thanks,
Christine

"Bernard Liengme" wrote:

Just add each one as a new data series and format to get the required
symbol
Tell us what type of chart so detailed steps can be provided
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Christine" wrote in message
...
I have an existing line chart. Four variables w/ five data points
each.
Simple.

My end user would like me to add a single data point for each of the
variables on the same scale but NOT connected to the rest of the
data
points
(ie, same symbol to represent each variable but not part of the line
of
the
line graph).

Is this possible? I can do it in Delta Graph fairly easily w/ an
overlay
but I'm not sure how to do it (or if I can) in Excel. This chart is
embedded
in a PPT presentation so I would prefer not replotting it in Delta
Graph.

Thanks!
Christine