FG
💻 Software

Excel 2007 - Custom Y-axis values

Fresh5 days ago
Mar 15, 202637128 views
Confidence Score0%
0%

Problem

I am making a basic column chart with a few columns. The only catch is instead of showing numbers as the grid marks, I want to show words like "Very Low" and "Medium". For example, I have So that would be 3 columns. Then I want Y-axis marks according to the following scale: Any way to do this in Ex…

Error Output

Data1 = 0.5
Data2 = 0.3
Data3 = 0.8

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel 2007 - Custom Y-axis values

Low Risk

There is no official support for this in Excel; however, there is a hack to make it work using a scatter plot. This method is a bit complicated, but does not require an add-on like the other answer. I figured this out using the info from here, but d…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment