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

Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...
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...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points. To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results. This overlay of graphs may seem like a difficult exercise but it is a very easy process. First you need to edit your "Plan" graph by clicking on its series and pres...