Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom Tom is offline
external usenet poster
 
Posts: 2
Default Excel 2003: How to make transparent columns in Excel chart?

If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default Excel 2003: How to make transparent columns in Excel chart?

Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
s.com...
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Excel 2003: How to make transparent columns in Excel chart?

Yes, I think it's for compatibility with shapes, and with Mac charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Andy Pope" wrote in message
...
Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
s.com...
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas




  #4   Report Post  
Posted to microsoft.public.excel.misc
Tom Tom is offline
external usenet poster
 
Posts: 2
Default Excel 2003: How to make transparent columns in Excel chart?

Thanks! That was very helpful indeed...
Could you tell me now where to find this dialog?


Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,489
Default Excel 2003: How to make transparent columns in Excel chart?

Hi,

Not sure what you mean by 'Find it'. The dialog is the one shown, for
example, when formatting a shape.
Select shape and press F1. On the Colors and Lines tab click the Color
dropdown.
From the list pick Fill Effects.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
oups.com...
Thanks! That was very helpful indeed...
Could you tell me now where to find this dialog?


Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy



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
EXCEL IS TRANSPARENT kimbcat Excel Discussion (Misc queries) 0 August 5th 06 06:40 AM
transparent level/limit in an Excel chart (3D) ju1eshart Charts and Charting in Excel 1 May 24th 06 07:53 PM
Transparent Chart Data Series stevepain Excel Discussion (Misc queries) 0 September 26th 05 04:43 PM
Semi transparent chart fill plainolddad Excel Worksheet Functions 0 June 22nd 05 10:55 PM
chart transparent fill plainolddad Charts and Charting in Excel 1 June 21st 05 08:19 PM


All times are GMT +1. The time now is 07:33 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"