Create a line graph in Excel - part 2

Introduction

This tutorial will guide you on how to enhance a line graph in Excel by adding meaningful colors, sizes, markers, and text. By customizing a simple line graph, you can effectively communicate your data and engage your audience for deeper understanding.

Step 1: Format the Axes

Begin by formatting the axes of your graph to improve clarity and presentation.

• Select the axes you want to format.
• Right-click on the axis and choose Format Axis.
• Adjust the minimum and maximum bounds to better fit your data.
• Consider changing the units to make the graph easier to read.

Step 2: Adjust the Colors

Adding color can significantly impact how your graph is perceived.

• Click on the line of your graph.
• Go to the Format Data Series option.
• Choose a color that aligns with your data's theme or message.
• Consider using different colors for multiple lines to distinguish them easily.

Step 3: Add Data Markers

Markers can provide visual cues for specific data points.

• Select the line graph.
• Go to Format Data Series again.
• Under Marker Options, select Built-in and choose a marker style.
• Adjust the size of the markers for better visibility.

Step 4: Experiment with Line Size

Varying the thickness of the lines can enhance visual appeal.

• While still in the Format Data Series menu, find the Line section.
• Adjust the width of the line to make it more prominent.
• Consider using a thicker line for primary data and thinner lines for secondary data.

Step 5: Use a Custom Graph Title

A descriptive title can provide context for your audience.

• Click on the existing title and select it.
• Type a new title that clearly describes what the graph represents.
• You can also adjust the font style, size, and color to match the graph's design.

Step 6: Modify Line Details

Fine-tuning the line characteristics can improve your graph's aesthetics.

In the Format Data Series pane, look for options to modify

• Line color: Choose a color that stands out.
• Line style: Opt for solid, dashed, or dotted lines based on your preference.
• Fill: If applicable, choose a fill option for area graphs.
• Adjust the transparency and other properties to enhance visibility.

Conclusion

By following these steps, you can create a customized line graph in Excel that effectively communicates your data story. Remember to keep your audience in mind and ensure that every visual element serves a purpose.

For further enhancement of your data visualization skills, consider exploring additional resources and workshops offered by Storytelling with Data. Happy graphing!