Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |