Skip to main content
Board of Directors
NEW! Sponsor an e-Learning Webinar
Key 2018 Annual Statement Changes (12-10-18)
2018 NAIC Summer Meeting Review
Excel Workshop - What is Your Challenge (Archived 8-7-2018)
US Tax Reform - Changes Today and Beyond (Archived 7-10-18)
Technology Innovation Award Winner Webinar (Archived 6-21-18)
2018 NAIC Spring Meeting Review (Archived 5-2-2018)
Economic Outlook 2018 (Archived 4-25-2018)
P&C Financial Accounting - Solution Provider Overview (Archived 4-3-2018)
Leveraging Blockchain Technologies to be Transformed (Archived 3-22-2018)
PowerPoint: Building Your Presentation from Scratch (Archived 2-15-2018)
How to Give Feedback (Archived 2/22/2018)
2017 NAIC Fall Meeting Review (Archived 1-10-18)
Key 2017 Annual Statement Changes_GAAP Update (Archived 12-18-17)
Economic Outlook 2018 (Archived 12-7-17)
Refreshing the NYDFS: Cyber Security Best Practices (Archived 11-16-17)
2017 NAIC Summer Meeting Review (Archived 10-12-17)
Excel Tips and Tricks: Dashboards (Archived 9-27-2017)
Expense Management and Budgeting (Archived 9-6-2017)
How to Act Like an Entrepreneur...(Archived 7-20-2017)
e-learning Internal Training Archive
In-Person Education Programs
Executive Education Program
Local Chapter Events
Solution Provider Program
Statutory Accounting Training
On-Line Education Programs
Other Education Resources
Continuing Education Credit
Skip breadcrumb navigation
Excel Tip of the Month - April 2017
By Aaron Cooper, Partner, Brown Smith Wallace
Charts are one of the best ways to visualize your data in Microsoft Excel. There are a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same no matter which type of chart you choose.
Follow these 5 simple steps to successfully create a chart in Excel.
Step 1: Select the cells
This is the easy part. Once you have entered your data, select the range of cells you would like displayed in the chart.
Step 2: Choose the type of chart
Next, go to the ‘Insert’ tab and select the type of chart that will best display your data. Generally, line charts are best used to display relationships, pie charts are best used to communicate compositions, and scatter plots are best used to show distributions.
Step 3: Switch axes, if necessary
If your data on the X and Y axis appear reversed, right click on the chart and click ‘Select Data,’ and click ‘Switch Row/Column.’
Step 4: Adjust your labels, if desired
To change the layout of the labeling, click on the chart, then click the ‘Layout’ tab. Here you can choose what layout you prefer for the chart and axes titles.
Step 5: Reorder data, if desired
To sort the data in descending popularity order, click on the column that is most important to you and click on the ‘Data’ tab, and click ‘Filter.’ Then go back to Column B, click the down arrow, and click ‘Sort Largest to Smallest.’
In order to make succeeding chart creation easier, save the charts you create as templates for future use.
Aaron is a partner in the Brown Smith Wallace Insurance Advisory Services practice. He is a regular content contributor to IASA national and the St. Louis chapter. You can reach Aaron at firstname.lastname@example.org.
Return to April eInterpreter