Monday, July 27, 2015

Charts in Excel

Thanks to the Live Charts feature in Excel, I can give charts an instant makeover with new, colorful charts. In older versions of Excel, charting was one of the more difficult tasks. It wasn’t only about the time it took, but also about the right chart type that fit the data. Excel 2013 makes it easy as a click with Live Charts. Excel uses a special algorithms to show the chart types you can use based on the data.




Select the data to chart and click Insert — Recommended Chart to see options such as line, bar, and pie charts that Excel feels is right for your data. Click each chart to preview what your data will look like. Pick the right chart and Excel inserts the chart with some page elements to work with styles, colors, and the chart data.




Do note: Not every chart type is recommended. Specialized chart types are available from the Insert Chart button on the Ribbon.

No comments:

Post a Comment