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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Sparklines: Column Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell.  A Column Sparkline is best used when you have lots of data points.You can style them in different colors and add a marker for the High and Low points of your data.  As your da...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can!To create an Excel Table you need to highlight your data and press CTRL+TSee Tutorial HereOnce you have your Excel Table you can add your Excel Sparklines inside one Column and us...
Excel Chart Marker Options The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points.To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are sel...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...