I'm a new user and this is my first posting. Any suggestions will be greatly
appreciated.

I've created a stacked bar chart with totals at the top of each bar. In
the totals area, only the Data Labels are visible. No patterns or borders
are showing, and that was intentional. The downside is that I can no longer
select the Data Series to make changes to it (such as adding a Series Line).
How can I change this so the Data Series is visible again?

Thanks in advance,

Lin,

Select the chart. Run this macro. Substitute the number of the top series. It will select
the series. Then use Format - Series from the menu bar.

Sub Macro1()
ActiveChart.SeriesCollection(3).Select
End Sub
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Lin" <(E-Mail Removed)> wrote in message
news34DDAF0-BE72-48C5-B136-(E-Mail Removed)...
> I'm a new user and this is my first posting. Any suggestions will be greatly
> appreciated.
>
> I've created a stacked bar chart with totals at the top of each bar. In
> the totals area, only the Data Labels are visible. No patterns or borders
> are showing, and that was intentional. The downside is that I can no longer
> select the Data Series to make changes to it (such as adding a Series Line).
> How can I change this so the Data Series is visible again?
>
> Thanks in advance,

Thanks Earl, it worked perfectly!
I appreciate your help!

"Earl Kiosterud" wrote:

> Lin,
>
> Select the chart. Run this macro. Substitute the number of the top series. It will select
> the series. Then use Format - Series from the menu bar.
>
> Sub Macro1()
> ActiveChart.SeriesCollection(3).Select
> End Sub
> --
> Earl Kiosterud
> www.smokeylake.com
>
> Note: Top-posting has been the norm here.
> Some folks prefer bottom-posting.
> But if you bottom-post to a reply that's
> already top-posted, the thread gets messy.
> When in Rome...
> -----------------------------------------------------------------------
> "Lin" <(E-Mail Removed)> wrote in message
> news34DDAF0-BE72-48C5-B136-(E-Mail Removed)...
> > I'm a new user and this is my first posting. Any suggestions will be greatly
> > appreciated.
> >
> > I've created a stacked bar chart with totals at the top of each bar. In
> > the totals area, only the Data Labels are visible. No patterns or borders
> > are showing, and that was intentional. The downside is that I can no longer
> > select the Data Series to make changes to it (such as adding a Series Line).
> > How can I change this so the Data Series is visible again?
> >
> > Thanks in advance,
>
>
>