ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Semi-circle chart in Excel 2003 (https://www.excelbanter.com/charts-charting-excel/157963-semi-circle-chart-excel-2003-a.html)

Oil Man Neil

Semi-circle chart in Excel 2003
 
Greetings.

Instead of a pie chart I'd like to use a fan chart, i.e. a semi-circle not a
circle.

If anyone knows how to do this or has a template please let me know.

Much appreciated.

Kind regards,
Neil

Andy Pope

Semi-circle chart in Excel 2003
 
Hi,

Make the first slice value equal to 50% and then set the Angle of first
slice to 90 degrees.
This will give you a large slice at the bottom. Format this to have no fill
and no border.

You can not move the plot are such that the slice is out of the chart area.
But you could use the large space for the legend on any textual information.
If the chart has no border then this is not so much of a problem.

Cheers
Andy



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Oil Man Neil" <Oil Man wrote in message
...
Greetings.

Instead of a pie chart I'd like to use a fan chart, i.e. a semi-circle not
a
circle.

If anyone knows how to do this or has a template please let me know.

Much appreciated.

Kind regards,
Neil



Oil Man Neil[_2_]

Semi-circle chart in Excel 2003
 
Thanks Andy.

"Andy Pope" wrote:

Hi,

Make the first slice value equal to 50% and then set the Angle of first
slice to 90 degrees.
This will give you a large slice at the bottom. Format this to have no fill
and no border.

You can not move the plot are such that the slice is out of the chart area.
But you could use the large space for the legend on any textual information.
If the chart has no border then this is not so much of a problem.

Cheers
Andy



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Oil Man Neil" <Oil Man wrote in message
...
Greetings.

Instead of a pie chart I'd like to use a fan chart, i.e. a semi-circle not
a
circle.

If anyone knows how to do this or has a template please let me know.

Much appreciated.

Kind regards,
Neil





All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com