How to Add Vertical Title in Excel Graph

A cluttered chart is an ineffective chart. When your audience has to squint and struggle to figure out what they’re looking at, your message gets lost. One of the quickest ways to clean up your data visualizations in Microsoft Excel is by properly labeling your vertical (Y) axis with a vertical title. This guide will walk you through exactly how to add, orient, and format vertical titles to make your graphs more professional and easier to read.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother with a Vertical Axis Title?

Dedicating a few seconds to labeling your vertical axis properly pays off immediately in two key ways: it saves space and improves clarity. Neglecting it can leave your audience guessing about what the data actually represents - are those numbers dollar amounts, unit counts, or something else entirely?

1. To Save Precious Chart Space

Horizontal space in a chart is valuable real estate. You want to give as much room as possible to the bars, lines, or data points themselves. A standard horizontal axis title, especially a long one like "Average Customer Revenue (in USD)," can awkwardly squish your chart, forcing the plot area to shrink.

By rotating the title 90 degrees to run parallel with the axis, you reclaim that horizontal space. This allows your data visualization to breathe and be the star of the show, which is particularly important when inserting charts into crowded dashboards, reports, or presentations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. To Improve Clarity and Readability

A labeled axis is non-negotiable for professional reporting. It removes all ambiguity about the data being presented. An unlabeled Y-axis with numbers like "50, 100, 150" is meaningless on its own. Is that $150? 150,000 units sold? 150 new sign-ups?

An axis title like "Monthly Sales ($)" instantly tells the story. It provides the context needed for your audience to understand the insights you're trying to share, turning a simple graph into a powerful piece of business intelligence.

Adding and Orienting Your Primary Vertical Axis Title

Getting your axis title to appear and rotating it vertically is a straightforward process. Let's walk through it step-by-step using a basic column chart as an example.

Step 1: Create Your Chart and Add the Axis Title Element

First, create your chart by highlighting your data and going to the Insert tab to choose your preferred chart type (e.g., Column, Bar, Line).

Once your chart is created and selected, you'll see a green plus sign ("+") icon appear to its upper-right corner. This is the Chart Elements shortcut.

• Click the "+" icon to open the Chart Elements menu.
• Hover over Axis Titles. You will see placeholder text boxes appear on both your vertical and horizontal axes.
• Check the box next to Axis Titles. This will add the "Axis Title" placeholders to your chart.

Now, simply click into the vertical axis's placeholder box and type in the title you want to use, such as "Total Revenue."

Step 2: Open the "Format Axis Title" Pane

With your placeholder text now updated, it's time to change its orientation. By default, Excel usually makes this title horizontal, which is exactly what we want to fix.

• Right-click on the vertical axis title you just created.
• From the context menu that appears, select Format Axis Title at the bottom.

This action will open a side panel on the right side of your Excel window, giving you full control over every aspect of the title's appearance.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Change the Text Direction

In the "Format Axis Title" pane, you might see several icons at the top. You're looking for the one that controls size and alignment.

• Click on the Size & Properties icon (it looks like a square with arrows indicating size).
• This will reveal several collapsible menus. Click on Alignment to expand it.
• You'll now see a "Text direction" dropdown menu. Click on it.

You have a few options here, each producing a different result:

• Horizontal: This is the default setting you started with.
• Rotate all text 90°: This orients the text to be read from bottom to top, but the letters themselves are not rotated.
• Rotate all text 270°: This is the most common and professional-looking option. It aligns the text to be read from top to bottom, making it perfectly parallel with the Y-axis.
• Stacked: This option stacks letters vertically one on top of the other. It should be avoided in almost all business contexts, as it is very difficult to read.

Select Rotate all text 270°. Your axis title will immediately snap into a professional vertical orientation. You can now close the formatting pane.

Advanced Case: Formatting a Secondary Vertical Axis

What if your chart has two different data series with vastly different scales? For example, showing "Sales Revenue" (in the thousands of dollars) and "Units Sold" (in the hundreds) on the same chart. The solution is a combination chart with a secondary vertical axis on the right side.

Luckily, the process for a secondary axis title is nearly identical.

Step 1: Create a Combo Chart and Add the Secondary Axis

If you don’t have one already, you’ll first need to create the secondary axis.

• Right-click on the data series you want to move to a secondary axis (e.g., "Units Sold").
• Choose Format Data Series.
• In the pane that opens, under Series Options, select the Secondary Axis radio button.
• You may also want to change its chart type (e.g., to a Line chart) for better visibility. You can do this by right-clicking the chart, selecting Change Chart Type, and choosing the "Combo" option at the bottom.

Step 2: Add and Format the Secondary Vertical Title

The steps here mirror the primary axis process, with one small difference.

• Select your chart and click the green "+" (Chart Elements) icon again.
• Hover over Axis Titles. This time, an arrow will appear next to it. Click the arrow.
• You will now see more options, including Primary Vertical and Secondary Vertical. Make sure both are checked.
• Type your desired text into the new "Secondary Vertical Axis Title" placeholder.
• Finally, repeat the formatting steps from before: Right-click the new title, select Format Axis Title, navigate to Size & Properties > Alignment > Text direction, and choose Rotate all text 270°.

Pro-Tips for Polishing Your Vertical Titles

Just because your title is vertical doesn't mean it's perfect. A little extra polish goes a long way.

Adjusting Font and Size

Your axis title should be easy to read but shouldn't overpower the rest of the chart. Select the axis title, then use the Home tab on the Ribbon to adjust the font, size, and color just like any other text. A font size that’s slightly smaller than the main chart title but similar to your axis labels usually works best.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Controlling Alignment

Within the Format Axis Title > Alignment settings, you can control the vertical alignment. This determines whether the text sits at the top, middle, or bottom of the title box. Choosing Middle keeps it perfectly centered along the axis line, which is generally the cleanest look.

Don't Go Overboard with Custom Angles

While the "Custom Angle" feature might seem tempting for creative charts, it's best avoided for professional business reports. Stick to the standard Rotate all text 270°. It is universally understood and maintains a clean, organized appearance.

Final Thoughts

Mastering vertical axis titles is a simple but high-impact skill that elevates your Excel charts from basic to professional. By properly labeling and orienting titles for both primary and secondary axes, you create visualizations that are clean, space-efficient, and easy for any audience to understand at a glance.

While Excel is a powerful tool, we know that getting reports right can feel like a constant battle, from wrangling CSVs to clicking through endless formatting menus. We built Graphed to eliminate that friction. Instead of manually building charts step-by-step, you can connect your data sources and simply ask for what you want in plain English - like "create a dashboard comparing our Shopify revenue against Facebook ad spend for the last quarter." It’s designed to give you back your time so you can focus on insights, not manual formatting.