Create chart in new worksheet

In this video, we’ll look at several different ways you can create charts in Excel. In later versions of Excel, starting with Excel 2013, the best option for creating a new chart is usually the Recommended Charts button on the Insert tab of the ribbon. Just select some data then go to Insert > …

In this video, we’ll look at options for customizing a category axis in an Excel chart. To recap, a value axis is used to plot numeric data on a scale, while a category axis is used to group text or dates into specific categories. In a previous video, we created a line chart to show average 30 year …

In this video, we’ll look at how to use a throwaway chart to explore data. In most cases, you’ll want to take time to build clean, uncluttered charts that are easy to read. However, a quick disposable chart is a great way to check and explore data. For example, in this worksheet, I have some sample …

You can change the default chart type by opening the Chart Type control on the ribbon, selecting a chart type, and clicking the set default button. This setting controls the default for all new charts in all workbooks. Note that hen you just randomly select cell in a set of data, Excel will try to …