Grey part of plot area

[cabUK]

I have created a gantt chart (using a chart not the cells) in Excel with the tasks going down one side and the dates across the top.

Basically somone wants me to shade previous days. In other words if the chart starts on the 1st Jan and its the 1st Feb he wants from the 1st Jan to 1st Feb dates shaded. With the remaning days left unshaded.

Is this possible? He has said he has seen it done but this is beyond my coding level. I would appreciate any help anyone can give on this.

Thanks in advance

Craig

 

[shetlandbob]

do you know how to manually change the color of the sections?

If so do it and record your actions into a macro.

Move this code into the OpenWorkbook event, and set an if statement on the date in the graph with the date on your computer. Your code will have to assume certain columns represent certain days (i.e. column 1 is Jan 1st say)

Robert Cumming

http://www.consultantengineer.co.uk

 

[cabUK]

No I dont know how to amnually change the colour of the sections. I was not even aware that you could do this manually.

Craig

 

[shetlandbob]

Neither fo I! I guess you would need to have dynamically changing plot areas then?

Can you create your graph in the format you want?

Robert Cumming

http://www.consultantengineer.co.uk

 

[xlbo]

to change the colour of different sections:

1: Select the entire series with a left mouse click
2: left mouse click again on the line / bar - you have now selected an individual data point
3: Either use the toolbar shortcuts for the fill pallette or RIGHT click with the mouse and choose "Format Data Point"
4: choose your colour

et voila

 

[SkipVought]

Hi,

You're refereing to something like a TIME NOW line, where everything to the LEFT of the TIME NOW line is shaded.

Add a range for TimeNow with the forumla, assuming that your dates are in column B...
[tt]
=IF(B2<=TODAY(),0,1)
[/tt]
copy the formula thru your data range.

Copy this range.

Select the chart

Edit/Paste Special

Select the new series

Chart/Chart Type - select COLUMN chart type for this series.

select the sheet and add a RECTANGLE from the Drawing toolbar.

Format the Rectangle using a FILL with a gray-tone AND semitransparent -- Line - NONE.

Copy the rectangle.

select the new series

Edit/Paste.

VOLA!

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More![/sub]