ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Invisible bar on bar chart (https://www.excelbanter.com/new-users-excel/119935-invisible-bar-bar-chart.html)

KK

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



Bernard Liengme

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





RajKohli

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




KK

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






All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com