I am trying to get a Pie chart to look like a compass

I would like to enter two values (X & Y) in the excel sheet in degrees
between 0 & 359 degrees

A1 = X
A2 = Y

The Pie chart should only have two colours. (i.e. black and white)

Each value (X & Y) should represent the side of the pie chart in degrees

Example

X=45 and Y = 90

Pie chart shows between 45 and 90 degrees

Can anybody give me some ideas how to achieve this please

TIA
C

On Fri, 15 Feb 2008, in microsoft.public.excel.charting,
Cathy said:
The Pie chart should only have two colours. (i.e. black and white)
X=45 and Y = 90
Pie chart shows between 45 and 90 degrees

Calculate your pie chart so it has three slices:

X
Y - X
360 - Y

Format the "X" and "360-Y" slices so they are invisible, and what's left
is your Y-X slice.

Example:

X = 45
Y - X = 90 - 45 = 45
360 - Y = 360 - 90 = 270

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.