Geek asks and answers

Conditional formatting along chart axis

I have a chart based chart.
The data in the table is conventionally formatted as a number or currency.

When formatting as a prime, the Y axis looks like this:

enter image description here

When formatting as a currency, the Y axis does not accept the same formatting. Is it intentional or an error in Excel? Is there a workaround? I do not want to use VBA in the solution, but any formula is, of course, beautiful.

enter image description here

+5
source share
3 answers

Edit - Actual Solution:

The solution to this complex problem was to use named ranges!

, ! . , , .

, . , .

, , . , , .

solution with named ranges

Edit:

, , . VBA- , VBA, , , .

:

enter image description here

, ;)

, .

+1

- , . , . =a1&" £",

+1

- , . , Named Ranges Offset. , .

0

More articles:


All Articles