Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KK KK is offline
external usenet poster
 
Posts: 12
Default Invisible bar on bar chart

Hello,

I have a stacked bar chart with 3 bars ie 'series' of data. I have made the
1st (bottom) bar invisible by setting its border, fill pattern etc to
'none'. So far so good.

I want to make the bar visible again, but I cannot find out how to 'select'
it in order to change its format! I need to double-click on it ? Am I
missing something ?

Help please ?

KK


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default Invisible bar on bar chart

With the chart selected, use the arrow keys and watch the Name box. When you
see the series you want click the Format item on menu bar
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"KK" wrote in message
...
Hello,

I have a stacked bar chart with 3 bars ie 'series' of data. I have made
the
1st (bottom) bar invisible by setting its border, fill pattern etc to
'none'. So far so good.

I want to make the bar visible again, but I cannot find out how to
'select'
it in order to change its format! I need to double-click on it ? Am I
missing something ?

Help please ?

KK




  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15
Default Invisible bar on bar chart

Shortcut Keys for charts
===============

Select the previous group of elements in a chart.
DOWN ARROW

Selects the next group of elements in a chart.
UP ARROW

For You
=====

Selects the next element within a group.
RIGHT ARROW

Selects the previous element within a group.
LEFT ARROW

This will help you, let us know!

"KK" wrote:

Hello,

I have a stacked bar chart with 3 bars ie 'series' of data. I have made the
1st (bottom) bar invisible by setting its border, fill pattern etc to
'none'. So far so good.

I want to make the bar visible again, but I cannot find out how to 'select'
it in order to change its format! I need to double-click on it ? Am I
missing something ?

Help please ?

KK



  #4   Report Post  
Posted to microsoft.public.excel.newusers
KK KK is offline
external usenet poster
 
Posts: 12
Default Invisible bar on bar chart - THANKS

Thanks for the help, your advice worked nicely

KK



"KK" wrote in message
...
Hello,

I have a stacked bar chart with 3 bars ie 'series' of data. I have made

the
1st (bottom) bar invisible by setting its border, fill pattern etc to
'none'. So far so good.

I want to make the bar visible again, but I cannot find out how to

'select'
it in order to change its format! I need to double-click on it ? Am I
missing something ?

Help please ?

KK




Reply
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
Sorting values in a bar chart Eric D Charts and Charting in Excel 4 April 17th 06 04:44 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 03:10 PM.

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"