seting months in y-axis chart reporting services

Question

seting months in y-axis chart reporting services

casagrandi

Old Hand

Points: 351
More actions
January 13, 2012 at 12:19 pm

#391309

Hello All,
My problem is concerning a chart in reporting services.
My dataset is looking as below:
MonthDue MonthDeleviry
------------ |----------------
Jan-2011 Mars-2011
Feb-2012 Jun_2013
Aug-2016 Oct-2014
....
...
.
ect
I want to make a graphique
MonthDue(Y-axis) /MonthDeleviry(X-axis) the problem is that Y-axis doesen't show label of month and convert it to FirstDayofMonth/MM/YYYY. It seems that this axis dont accepte String value and allow just Numeric and date Format dd/mm/YYYY.
Excuse my bad english
Can you help please.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

larskandersen Ten Centuries Points: 1232 More actions · Answer 1

http://technet.microsoft.com/en-us/library/dd220510.aspx

Qoute: A chart data region commonly shows dates along the category (x) axis, and values along the value (y) axis. To specify formatting in a chart, right-click an axis and select Axis Properties. On the value axis, you can specify formats only for numbers.

casagrandi Old Hand Points: 351 More actions · Answer 2

thanks for reply larskandersen.

I know this information the product can't propose this option . I want some tip or hack to pass through it 🙂

larskandersen Ten Centuries Points: 1232 More actions · Answer 3

Could you post a mockup of your chart? Based on your current input, I am not certain what you’re looking for; however have you looked at a table inline chart? That way you control the label.

casagrandi Old Hand Points: 351 More actions · Answer 4

Ok you will find more details in the shema bellow: