How to display graph using numbers but display text in table.

[Philter]

Good day,

I generated a line/scatter graph for the sample data below:

Point 1 Point 2 Point 3 ......
Date1 20 30 25
Date2 22 30 22
Date3 19 30 28
Date4 22 30 29

This is all well and good. I am able to generate the graph not problem..... However, in addition to the graph, I also need to display the table in the same report. Where I am getting stuck is that I would like to replace the values shown for "Point 2" with text.

I want the graph to show a line for "Point 2" representing the value of "30", but in the table I want each cell in the "Point 2" column to read "MAXIMUM" instead of 30.

I know that this could be done with a reference table using an IF() or other formulas. However, for a variety of reasons, I would like to know if this is possible within the same table.

Any guidance on this topic would be most helpful.

Thanks.

 

[Hui]

It doesn't appear possible

I originally thought of using a Custom Number Format
like: [>=30]"Maximum";[<30]#,##0;-#,##0
But the Table isn't part of the axis and Custom Number Formats are not applicable property

I'll keep investigating