LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Lines appearing in front of bar but invisible behind bar labels?

Hi: I'm trying to build a bar chart that has horizontal white lines running
across the chart at the major y-axis tick marks. I want them to layer on top
of the blue bars but back behind any bar labels they might happen to cross,
so they're visible only where they cross the bars.

Reading previous posts, I've tried selecting the chart before drawing the
lines, so they are embedded within the chart, as well as leaving them
independent. Either way, I don't seem to be able to accomplish my goal. An
earlier posting response by Andy Pope says: "If you use a shape within the
chart I don't think you will be able to change the layer it's on. It will
always be above the charting elements." Does that mean I'm hosed? His
suggestion in that posting had to do with adding a dummy series. I don't
think would work for my purposes, unless my imagination and skills are just
too limited (a distinct possibility).

Any ideas? This is the first time I'm using this resource. Thanks much to
all you MVPs out there, who seem so cheerful about advising us poor clods.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invisible comments and chart labels Ryan Excel Discussion (Misc queries) 0 September 12th 07 05:58 AM
Invisible precedent lines. The system draws them but I can't see t EJKorvette Excel Worksheet Functions 0 September 1st 06 07:20 PM
Help with labels and lines in chart crash893 Charts and Charting in Excel 1 July 21st 06 12:55 PM
"Bring to Front" Data Labels? Rob Charts and Charting in Excel 2 April 3rd 05 04:59 PM
Why are Excel 2003 chart arrows and lines invisible with little c. Len Charts and Charting in Excel 1 April 1st 05 03:09 PM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"