How to Insert a Line with Markers Chart in Excel

A line chart is perfect for showing a trend over time, but what if you need to highlight the specific data points along that trend? That's where Excel's "Line with Markers" chart comes in handy, giving you the best of both worlds. This step-by-step tutorial will show you exactly how to create, customize, and use this powerful chart type to make your data clear and compelling.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Line with Markers Chart?

Think of it as a standard line chart with an upgrade. It plots your data points on a graph and connects them with a continuous line to show a trend, just like a regular line chart. The key difference is the addition of "markers" - small symbols like circles, squares, or diamonds - at each individual data point.

This simple addition serves a crucial purpose:

• The Line Shows the Trend: It gives you the big-picture view, making it easy to see if your numbers are going up, down, or staying flat over a period.
• The Markers Highlight Specific Points: They draw the viewer's eye to the exact value at each interval (e.g., the sales figure for each month). This stops ambiguity and makes the individual data points easy to read.

This chart type is incredibly useful for visualizing time-series data where both the overall trend and the individual values at each point in time are important. Common examples include:

• Tracking monthly revenue or sales figures over a year.
• Monitoring weekly website traffic or user sign-ups for a quarter.
• Comparing daily temperature readings or stock prices.
• Showing a project's completion percentage at various milestones.

Preparing Your Data for the Chart

Before you even think about clicking the "Insert" tab, getting your data organized correctly is the most important step. Good chart-making starts with a clean, logical data structure. Thankfully, the setup for a line chart is very straightforward.

You’ll need at least two columns of data:

• Column 1 (Horizontal Axis): This column should contain your time periods or categories. These are the labels that will run along the bottom (the X-axis) of your chart, such as months, quarters, days of the week, or project phases.
• Column 2 (Vertical Axis): This column must contain the corresponding numerical values you want to measure. These are the data points that will be plotted along the vertical (Y-axis) of your chart, such as sales figures, user counts, or percentages.

Here’s what an ideal data set looks like:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tips for Clean Data:

• Use Headers: Always have a clear header for each column (like "Month" and "Units Sold"). Excel will use these to automatically label parts of your chart.
• No Blank Rows or Columns: Ensure your data set is a single, continuous block. Blank rows or columns in the middle can confuse Excel and lead to an incorrectly plotted chart.
• Keep Formatting Consistent: Make sure your dates are all formatted as dates and your numbers are formatted as numbers (e.g., currency, general).

How to Create a Line with Markers Chart in Excel (Step-by-Step)

Once your data is neatly arranged, creating the chart takes less than a minute. Follow these simple steps.

Step 1: Select Your Data

Click and drag your mouse to highlight the entire range of data you want to include in the chart. Be sure to include the column headers, as this will help Excel create automatic labels for you.

Step 2: Navigate to the Insert Tab

At the top of the Excel window, click on the "Insert" tab on the main ribbon.

Step 3: Locate the Charts Group

In the Insert tab, look for the section labeled "Charts". This group contains icons for all the different chart types available in Excel.

Step 4: Click the Line Chart Icon

Find and click the icon that looks like a small line graph. It’s officially called the "Insert Line or Area Chart" icon. Clicking it will open a dropdown menu with several line chart options.

Step 5: Choose "Line with Markers"

In the dropdown menu, under the "2-D Line" section, you will see several options. Hover your mouse over them to see a preview. The fourth option is typically labeled "Line with Markers". Click it.

That's it! Excel will instantly place a new Line with Markers chart onto your worksheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Customize Your Excel Chart

Your basic chart is created, but the default styling might not be perfect. Customizing your chart is key to making it clear, professional, and easy to read. Simply click on your chart to get started, which will make two new contextual tabs appear on the ribbon: "Chart Design" and "Format".

Change the Chart Title and Axis Labels

The generic title is the first thing you should change. Simply click on the "Chart Title" text box directly on the chart and type in a descriptive title, like "Quarterly Unit Sales."

If you need to add labels for your horizontal or vertical axes, select the chart, go to the Chart Design tab, and click: Add Chart Element > Axis Titles > Primary Horizontal or Primary Vertical. A text box will appear for you to edit.

Customize the Line and Markers

This is where you make your chart visually appealing and emphasize the data. Right-click directly on the data line in your chart and select "Format Data Series..." from the menu. This opens a sidebar panel with all your formatting options.

To format the line:

1. In the "Format Data Series" panel, click the paint bucket icon (Fill & Line).
2. Click on the "Line" section to expand it.
3. Here, you can change the line's Color, Width (thickness), and Dash type (e.g., making it dotted or dashed instead of solid).

To format the markers:

1. In the same panel, click on the "Marker" section.
2. Click "Marker Options." Here you can change the Type of marker (circle, square, triangle, etc.) and adjust its Size.
3. Below that, you can change the marker's Fill (its main color) and Border (its outline color and thickness).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Add and Position Data Labels

Sometimes, you want the exact numerical value displayed next to each marker. This saves your audience from having to guess the value based on the axis.

1. Select the chart.
2. Go to the Chart Design tab.
3. Click Add Chart Element > Data Labels.
4. Choose where you want the labels to appear, such as Above, Below, or Center. "Above" is often the cleanest option.

You can then right-click the data labels themselves and choose "Format Data Labels" to change the font, color, or number format (e.g., adding a dollar sign).

Adjust the Axes and Gridlines

You can fine-tune the scale and appearance of your axes for better clarity.

• To edit an axis, right-click on it (either the vertical numbers or horizontal labels) and select "Format Axis...". This allows you to manually set the minimum and maximum boundary values, change the major units (the intervals between labels), and modify the number formatting.
• To add, remove, or style gridlines, go to Chart Design > Add Chart Element > Gridlines and select the options you prefer. Sometimes, reducing the visual clutter by removing minor gridlines can make a chart much easier to read.

Final Thoughts

The line with markers chart is a fantastic tool in Excel for showing trends while keeping individual data points clearly visible. By preparing your data properly and using the customization options, you can turn a simple dataset into a professional and insightful visualization that tells a clear story.

While mastering charts in Excel is a valuable skill, it often comes after the tedious work of manually exporting CSVs from a dozen different platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce. For those situations, we built Graphed to do the heavy lifting. We connect to all your marketing and sales data sources automatically, so you can build real-time, interactive dashboards just by asking questions in plain English. This eliminates the manual data wrangling and lets you get straight to the insights, not the setup.