Cycle Charts in Excel are easy to create using the Smart Art feature.

There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle.

Here is how you insert a Radial Cycle:

Excel Cycle Chart
Excel Cycle Chart

STEP 1: Click on Insert > Smart Art > Cycle > Radial Cycle

STEP 2: Enter the cycle title by clicking on a shape

STEP 3: To enter a new cycle, you need to click on a shape and select SmartArt Tools > Design > Add Shape (You can also right click on the shape and choose this option)

STEP 4: To move the cycle upwards or downwards, you need to click on a shape and select SmartArt Tools > Design > Move Up or Move Down

STEP 5: To change the cycle from right to left, you need to click on a shape and select SmartArt Tools > Design > Right to Left

STEP 6: To change the color of the cycle, you need to click on a shape and select SmartArt Tools > Design > Change Colors

STEP 7: Under SmartArt Tools > Design > SmartArt Styles drop down you can change the style of your cycle

Watch the tutorial below to see how easy a Cycle Chart is created in Excel:

DOWNLOAD WORKBOOK

Excel Cycle Chart

HELPFUL RESOURCE:

Bill_Jelen_Podcast_Banner_EXCEL

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data. The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...
Change the Axis Units in an Excel Chart Whenever you create a chart in Excel, it gives you the default vertical Axis based on the values that are in your data set. If you have large numbers in your data, like tens or hundreds of millions of dollars, then the vertical axes will take up lots of real estate space in yo...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...