Embedded Chart in Excel Sheet

I have an embedded chart on sheet 1. It looks exactly like what I want--
EXCEPT
--neither source cell values or trend lines are plotted. When I click on the
embedded chart, the values of the column are highlighted, but nothing happens
in the plot area.
A Child in the Wilderness!

1. The data may be plotted, but way off scale.

2. The data may be plotted, but the series are hidden (no line, no marker).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


George wrote:

> I have an embedded chart on sheet 1. It looks exactly like what I want--
> EXCEPT
> --neither source cell values or trend lines are plotted. When I click on the
> embedded chart, the values of the column are highlighted, but nothing happens
> in the plot area.
> A Child in the Wilderness!

I don't think the data is off scale, but I must look into "hidden lines &
markers". How do I determine if hidden lines & markers exist? Thanks for
your response, it has given me a path to investigate.
--
A Child in the Wilderness!


"Jon Peltier" wrote:

> 1. The data may be plotted, but way off scale.
>
> 2. The data may be plotted, but the series are hidden (no line, no marker).
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> George wrote:
>
> > I have an embedded chart on sheet 1. It looks exactly like what I want--
> > EXCEPT
> > --neither source cell values or trend lines are plotted. When I click on the
> > embedded chart, the values of the column are highlighted, but nothing happens
> > in the plot area.
> > A Child in the Wilderness!
>

Select the chart, then use the dropdown in the Chart toolbar to select a
series or trendline. Objects are hidden by formatting them (use Ctrl-1,
numeral one, to format a selected object) with no line, no marker, no
fill, etc. If the series is in-scale but hidden, you'll still see it
highlighted when it's selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


George wrote:
> I don't think the data is off scale, but I must look into "hidden lines &
> markers". How do I determine if hidden lines & markers exist? Thanks for
> your response, it has given me a path to investigate.