Chart with Colored Background - Log Log Scale
 

I have attempted to make a chart with colored background
http://www.peltiertech.com/Excel/Cha...ackground.html
but want the data that's plotted on the chart to be on a log log scale.
Can someone assist? When I change the X and Y axes to Log scale, the
background is skewed.

Thanks in advance,
Barb Reinhardt

Hi Barb,

I knocked up a quick example with some steps.
www.andypope.info/ngs/loglogquad.zip

Only thing I did different to Jon's example is to start with the xy
data, that way you don't need to fiddle with the position of the log/log
axis in terms of bottom and left. Although I had no problem using Jon's
example.

Cheers
Andy

Barb Reinhardt wrote:
I have attempted to make a chart with colored background
http://www.peltiertech.com/Excel/Cha...ackground.html
but want the data that's plotted on the chart to be on a log log scale.
Can someone assist? When I change the X and Y axes to Log scale, the
background is skewed.

Thanks in advance,
Barb Reinhardt



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info