change the category axis label text on a graph datawindow

1
0
-1

Trying to change the category axis label text on a graph datawindow to include custom information

Currently I have the category axis text being a date in mmm dd format.   I would like the date to include parens with a integer to show a value at that date.. Something like:

01 May (233)       01 Jun (-234)       01 Jul (-500)

I have the extra value available in another column in my datawindow.

Any ideas how to accomplish this?

Regards,

Ephraim.

Question Tags: 

Answers

Chris Pollach answered change the category axis label text on a graph datawindow

1
0
-1

Hi Ephraim;

  You will need to create a character based SQL Computed Column that matches the format of the date + number format that you require. You can then map the Value Axis Text to that SQL CC as the display value. That should  give you the value formatting that you need. For example ...

HTH

Regards ... Chris

ephraim@ccimail.com's picture

Chris, Did you mean the "Category Axis Text" ?  When I try to it the expression dialog to paste, it does not allow me to put other columns into the expression, only the category, title, seriesaxislabel etc.     (can't seem to get an image to paste here so I can show you)

Chris Pollach's picture

Could be used then on either axis' text property.  It just depends on where you need the specially formatted date. Your choice.  wink

ephraim@ccimail.com's picture

I still can't get a the axis' text property to show an alternative column... this is my basic problem