Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Michel Dion (from IMS Health in Canada)
 
Posts: n/a
Default fill series grayed out (not available, disactivated)

I have been wondering for some time why the fill series functionality is
sometime not available. When you right-click on the fill handle and drag it
to fill adjacent cells, the series option is grayed out in the menu and there
is no way to get Excel to do anything other than copying cell values.

I searched the Web and couldn't find an answer, so I decided to share my
findings.

I know for shure adding auto-filters to a spreadsheet deactivates the fill
series functionality. If you are aware of any other reasons why it may be
deactivated, please share it here.
  #2   Report Post  
Michel Dion (from IMS Health in Canada)
 
Posts: n/a
Default

BTW, here is my workaround to the problem, I simply create a new workbook,
create the series I want, and then copy and paste it in the original
worksheet.

Hope it helps.
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
Plotting different length series in a chart Big Red Charts and Charting in Excel 2 May 5th 05 02:00 PM
Help! I'm losing one series of data in an overlay chart. Charts are Us Charts and Charting in Excel 1 January 4th 05 06:57 PM
Excel Fill Series electromott Excel Discussion (Misc queries) 2 December 16th 04 03:55 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 05:45 AM
How do I force a series in a Bar-Line Chart to be a Bar? Excel Challenged Charts and Charting in Excel 1 December 6th 04 05:16 AM


All times are GMT +1. The time now is 04:26 PM.

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

About Us

"It's about Microsoft Excel"