chart category field

On the category fields, how is it possible to show the first and the last
values. I.e. the x-axis to show the min value at the start and the max value
at the end.
This is what i have so far but the x-axis displays nothing on the line
=IIf(Min(Fields!Import_Date.Value),Fields!Import_Date.Value,"")This is a work around which I have used in the past but may not be
what you want. You can turn off the axis and create a table item under
your chart to simulate what you are after.
On Nov 20, 11:20 pm, arkiboys2 <arkibo...@.discussions.microsoft.com>
wrote:
> On the category fields, how is it possible to show the first and the last
> values. I.e. the x-axis to show the min value at the start and the max value
> at the end.
> This is what i have so far but the x-axis displays nothing on the line
> =IIf(Min(Fields!Import_Date.Value),Fields!Import_Date.Value,"")|||What is a table item please?
"shaikat.das@.gmail.com" wrote:
> This is a work around which I have used in the past but may not be
> what you want. You can turn off the axis and create a table item under
> your chart to simulate what you are after.
>
> On Nov 20, 11:20 pm, arkiboys2 <arkibo...@.discussions.microsoft.com>
> wrote:
> > On the category fields, how is it possible to show the first and the last
> > values. I.e. the x-axis to show the min value at the start and the max value
> > at the end.
> >
> > This is what i have so far but the x-axis displays nothing on the line
> >
> > =IIf(Min(Fields!Import_Date.Value),Fields!Import_Date.Value,"")
>|||In visual studio , under the toolbox, youll find a table . Drag that
onto the designer, under the x-axis . Make the width of the table same
as the width of your graph and turn off header and footer on the
table. Then create a dataset which has the least and max values which
you want to show on your x axis. Tie this data set to your table and
place the least value in the first cell and the max value in the last
cell. Turn off your x axis and play with the table till you get it to
look like what you need.
Cheers
Shai
On Nov 21, 8:47 pm, arkiboys2 <arkibo...@.discussions.microsoft.com>
wrote:
> What is a table item please?
>
> "shaikat...@.gmail.com" wrote:
> > This is a work around which I have used in the past but may not be
> > what you want. You can turn off the axis and create a table item under
> > your chart to simulate what you are after.
> > On Nov 20, 11:20 pm, arkiboys2 <arkibo...@.discussions.microsoft.com>
> > wrote:
> > > On the category fields, how is it possible to show the first and the last
> > > values. I.e. the x-axis to show the min value at the start and the max value
> > > at the end.
> > > This is what i have so far but the x-axis displays nothing on the line
> > > =IIf(Min(Fields!Import_Date.Value),Fields!Import_Date.Value,"")- Hide quoted text -
> - Show quoted text -