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" wrote in message
...
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" wrote in message
...
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,