Excel: Charts and Graphs
Charts and graphs are the most popular tools for visualizing data. Learn how to make insights into your data clear, easy to understand, and visually attractive.
Related LibGuide: Data Visualization by Rachel Starry
- Tuesday, January 14, 2020
- 9:00am - 3:00pm
- 310 Silverman Library
- North Campus
Using Microsoft Excel, we will create and format charts and graphs. This workshop is designed to bring novice users to proficient or expert on covered topics. You are invited to bring your own data sets to work on. After this workshop you will be familiar with:
- How to choose a chart type
- Avoiding clutter
- The reason why 3D pie charts are in disfavor
- Naming, selecting and formatting chart elements
- The difference between a chart and a PivotChart
- Axis options: tick marks, labels, numer formats
- Legend format
- Ideas, recommended charts and charts
- Special chart formats for engineers
- How to make charts having rounded corners
- COLUMNS and ROWS worksheet functions
- Trend lines
- Saving charts as pictures
- Quick layouts
- How to work with institutional branding with charts
- How to make, save and distribute an Office Theme
- Make a HISTOGRAM
- Animate a chart in PowerPoint
- Make a PivotTable Timeline
- Make a People graph
- Make exotic charts
- PowerMap for 3D charts of geographic information
- Making a chart movie
- Making a 3D chart using time data with geographic data from PowerQuery's data model
- Make Visio components in Excel
Workshops are offered at no charge to UB faculty, staff, students and alumni.
Please remember to bring your own device to the workshop. The classroom does not have workstations.
Attendees are encouraged to update Microsoft Office prior to attending.
To get a free Microsoft Office 365 subscription for current faculty, staff or student privately owned devices click here.
Co-sponsored by The Graduate School.