Where is chart tools in excel

First, you need to input your data into Excel. You might have exported the data from elsewhere, like a piece of marketing software or a survey tool.

Or maybe you're inputting it manually. In Excel, your options for charts and graphs include column or bar graphs, line graphs, pie graphs, scatter plots, and more. See how Excel identifies each one in the top navigation bar, as depicted below:.

To make a bar graph, highlight the data and include the titles of the X and Y-axis. Then, go to the Insert tab, and in the charts section, click the column icon. Choose the graph you wish from the dropdown window that appears.

In this example, I picked the first 2-dimensional column option — just because I prefer the flat bar graphic over the 3-D look. See the resulting bar graph below. This will rearrange which axes carry which pieces of data in the list shown below. When you're finished, click OK at the bottom. To change the layout of the labeling and legend, click on the bar graph, then click the Chart Design tab.

Here, you can choose which layout you prefer for the chart title, axis titles, and legend. In my example shown below, I clicked on the option that displayed softer bar colors and legends below the chart.

To further format the legend, click on it to reveal the Format Legend Entry sidebar, as shown below. Here, you can change the fill color of the legend, which will in turn change the color of the columns themselves.

To format other parts of your chart, click on them individually to reveal a corresponding Format window. When you first make a graph in Excel, the size of your axis and legend labels might be a bit small, depending on the type of graph or chart you choose bar, pie, line, etc. Once you've created your chart, you'll want to beef up those labels so they're legible. To increase the size of your graph's labels, click on them individually and, instead of revealing a new Format window, click back into the Home tab in the top navigation bar of Excel.

Then, use the font type and size dropdown fields to expand or shrink your chart's legend and axis labels to your liking. To change the type of measurement shown on the Y axis, click on the Y-axis percentages in your chart to reveal the Format Axis window.

Here, you can decide if you want to display units located on the Axis Options tab, or if you want to change whether the Y-axis shows percentages to 2 decimal places or to 0 decimal places.

To do so, I can select the Maximum option — two fields down under Bounds in the Format Axis window — and change the value from 0.

The resulting graph would be changed to look like the one below I increased the font size of the Y-axis via the Home tab, so you can see the difference :. To sort the data so the respondents' answers appear in reverse order, right-click on your graph and click Select Data to reveal the same options window you called up in Step 3 above. This time, click the up and down arrows, as shown below, to reverse the order of your data on the chart.

If you have more than two lines of data to adjust, you can also rearrange them in ascending or descending order. To do this, highlight all of your data in the cells above your chart, click Data and select Sort, as shown below. You can choose to sort based on smallest to largest or largest to smallest, depending on your preference. Now comes the fun and easy part: naming your graph.

By now, you might have already figured out how to do this. Here's a simple clarifier. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. Microsoft PnP. Healthcare and Life Sciences. Internet of Things IoT. Enabling Remote Work. I actually prefer this over pasting as a picture because it tends to flow with the rest of your powerpoint much better.

Now you know how to create a simple chart with Excel data, customize it, and make your presentation come alive. Endsight delivers premium IT management and support to small and medium-sized businesses of all industries. Our service combines trained IT professionals with sophisticated automation and remote management technology to create reliable networks that lever our clients' business model, mission, and people. Careers Sales General: info endsight. Creating Excel Charts This Quick Tip will teach you how to create a chart in Excel with customized colors, fonts, and styles.

Learn more. About us. Contact us.