Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Need help with macro to format a chart

Hi,

My pivot table chart is showing data for different dates (each field in the
legend is a date). How can I write a macro that will format the lines for
past dates as dotted lines and future dates as plain lines ?

Tks for your help

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
Macro to change position of chart labels on line chart Shane Henderson[_2_] Charts and Charting in Excel 1 May 27th 11 09:31 AM
macro to keep chart dual axis format kay Excel Programming 1 November 21st 08 08:56 PM
Macro to convert mmddyyyy format into mm/dd/yyyy format maijiuli Excel Programming 2 March 10th 08 11:58 PM
Format Pie Chart am Charts and Charting in Excel 1 March 14th 07 07:19 PM
Conditional Format - Format Transfer To Chart ju1eshart Excel Discussion (Misc queries) 0 June 1st 06 02:46 PM


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