ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Simulating a Zodiac with a chart (https://www.excelbanter.com/charts-charting-excel/224330-simulating-zodiac-chart.html)

gtslabs

Simulating a Zodiac with a chart
 
I want to make a circular chart similar to a Zodiac but I want to
color sections similar to a pie chart.
I have plotted this before using Sin/Cos of the degree but did not
have the ability to color the pie shape pieces.
Is this possible?

So say I want from 360* (top dead center) to 90* (left quadrant) to be
shaded, how would I do this and with what type of chart?

Andy Pope

Simulating a Zodiac with a chart
 
Hi,

Donut chart will provide the shaded circular sections.

Cheers
Andy

gtslabs wrote:
I want to make a circular chart similar to a Zodiac but I want to
color sections similar to a pie chart.
I have plotted this before using Sin/Cos of the degree but did not
have the ability to color the pie shape pieces.
Is this possible?

So say I want from 360* (top dead center) to 90* (left quadrant) to be
shaded, how would I do this and with what type of chart?


--

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

Shane Devenshire

Simulating a Zodiac with a chart
 
Hi,

If I understand just set up a data area like this

Aries 10
Taurus 10
Gemini 10
Cancer 10
Leo 10
Virgo 10
Libra 10
Scorpio 10
Sagittarius 10
Capricorns 10
Aquarius 10
Pisces 10

All the values being the same and plot it as a Pie.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"gtslabs" wrote:

I want to make a circular chart similar to a Zodiac but I want to
color sections similar to a pie chart.
I have plotted this before using Sin/Cos of the degree but did not
have the ability to color the pie shape pieces.
Is this possible?

So say I want from 360* (top dead center) to 90* (left quadrant) to be
shaded, how would I do this and with what type of chart?



All times are GMT +1. The time now is 05:29 AM.

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