MSChart

[Cathy]

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

 

[Del Cotter]

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