Excel Sparklines are mini charts that live in a single cell, giving you a quick visual of your data. With just a glance, you can ...

An X-Y scatter chart is an ideal plot choice when you have data sets with at least two interesting variables per record, and because scatter plots are a native graph option in Excel, you simply ...

Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart. Click the "Insert" tab, and then select the chart type and sub ...

Open up the Excel spreadsheet where you can find the desired chart. Then, select the chart in the spreadsheet and right-click on it. In the context menu, you will see an option called Select Data.

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

However, it’s easy enough to display the hidden data for those times when you do. To display hidden data in a chart, do the following: Select the chart. From the Tools menu, choose Options.

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

Select Cells A1:H1 (X-axis values) and Cells A15:H15 (rep name and related sales data) and click Insert, Recommended Charts, and select Line chart from the top of the list.