hi,
How can i change the color property of the line in the line chart.
For bar charts and all i go to series style and change it.
but for line chart, default comes to green - and i would like to change it
to red.
thanksFor line charts, you need to change the series style border line color
(instead of the color property).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramani" <Ramani@.discussions.microsoft.com> wrote in message
news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> hi,
> How can i change the color property of the line in the line chart.
> For bar charts and all i go to series style and change it.
> but for line chart, default comes to green - and i would like to change it
> to red.
> thanks
>|||Hi All,
I have a line a line chart where there are 2 lines.one of the line seems to
be hidden im not sure y' only one line is displayed at a time...
Can any1 let me know of my problem,
Thanks,
"Robert Bruckner [MSFT]" wrote:
> For line charts, you need to change the series style border line color
> (instead of the color property).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ramani" <Ramani@.discussions.microsoft.com> wrote in message
> news:8A2BA0F6-A412-40EC-A316-B9D5F9D44889@.microsoft.com...
> > hi,
> > How can i change the color property of the line in the line chart.
> > For bar charts and all i go to series style and change it.
> > but for line chart, default comes to green - and i would like to change it
> > to red.
> > thanks
> >
>
>
Showing posts with label bar. Show all posts
Showing posts with label bar. Show all posts
Wednesday, March 21, 2012
Line in a bar chart.
Does anyone know how to print a line on a bar chart....
Basically I have two series for the chart. The first series would appear as a bar chart. The second as a line.
ThanksIn the Report Designer, go to the Chart Properties dialog. Click on the Data tab, select the data point you want to make a line, click 'Edit..'. In the chart value dialog, click on the Appearance tab and select 'Plot Data as Line'.
Line graph on bar chart
Does anyone know if it is possible to create a graph where a line is on top
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success
Monday, March 19, 2012
Line Chart Line Color
Is it possible to change line color in the line chart. I can change series
color in a bar chart, but cannot seem to change the color of the lines when
selecting a smooth line chart.
-ChrisThe relevant property in line charts is the border line color property.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:4852411A-7B54-4A8D-9E19-E3787F9D1656@.microsoft.com...
> Is it possible to change line color in the line chart. I can change
series
> color in a bar chart, but cannot seem to change the color of the lines
when
> selecting a smooth line chart.
> -Chris
color in a bar chart, but cannot seem to change the color of the lines when
selecting a smooth line chart.
-ChrisThe relevant property in line charts is the border line color property.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:4852411A-7B54-4A8D-9E19-E3787F9D1656@.microsoft.com...
> Is it possible to change line color in the line chart. I can change
series
> color in a bar chart, but cannot seem to change the color of the lines
when
> selecting a smooth line chart.
> -Chris
Line Chart Color
Hello,
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Michael
To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||Merin,
I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?
Michael
|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.
Michael
|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).
however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x
(refer to code snippet)
and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.
rev-boy
=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)
Line Chart Color
Hello,
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Michael
To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||Merin,
I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?
Michael
|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.
Michael
|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).
however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x
(refer to code snippet)
and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.
rev-boy
=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)
Friday, March 9, 2012
Limiting bars on a chart?
Hi, I have a chart control that is working very nicely indeed.
Is there a simple way to limit the number of bar that are drawn? I.e. I only
want say the top 10 bars showing. My dataset is large and displayed 300 bars
is too much/a mess.
I dont want to filter the dataset, as the bars are constructed from
aggregate data (sums and counts). I do not see a simple limit, or am I
missing something?
Any tips appreciated!
Kind regards
TazYou can use the TOP(N) on the dataset then link ht echart to that dataset.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
> Hi, I have a chart control that is working very nicely indeed.
> Is there a simple way to limit the number of bar that are drawn? I.e. I
> only want say the top 10 bars showing. My dataset is large and displayed
> 300 bars is too much/a mess.
> I dont want to filter the dataset, as the bars are constructed from
> aggregate data (sums and counts). I do not see a simple limit, or am I
> missing something?
> Any tips appreciated!
> Kind regards
> Taz
>|||Hi Ben, thanks for the response below.
I have tried this and am having problems, please see my post below. What
would you suggest? How can I use the TOP N syntan on an aggregate field?
Thanks
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
> You can use the TOP(N) on the dataset then link ht echart to that dataset.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>|||go to your category group in you chart that you want to limit and edit it
and click the filter tab. In the expression enter the value formula then us
e the top N in the formula column, and =10. That just worked for one of my
charts. If you have any problems i will explain it better.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
> Hi Ben, thanks for the response below.
> I have tried this and am having problems, please see my post below. What
> would you suggest? How can I use the TOP N syntan on an aggregate field?
> Thanks
> Taz
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>|||Let me try to explain again. Put your sum or count formula from your value
field into the expression column. Use the Top N from the operator column
and put =10 in the value column. DO all of this in the category group that
you want filtered.
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
> go to your category group in you chart that you want to limit and edit it
> and click the filter tab. In the expression enter the value formula then
> us e the top N in the formula column, and =10. That just worked for one
> of my charts. If you have any problems i will explain it better.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>|||Ben, I am SUCH an idiot.
Your advise is flawless and what you state is correct. Unfortunately, this
is what I was doing and wasn't seeing the results I wanted. The reason why?
Many of my columns have the same value (e.g. 4) so when limiting to the top
10, i wondered why I could still see 16+, the last 8 fields were all the
same value.
I wonder if this should be happening. I would like to purge my set to
exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
filters on date?
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Let me try to explain again. Put your sum or count formula from your
> value field into the expression column. Use the Top N from the operator
> column and put =10 in the value column. DO all of this in the category
> group that you want filtered.
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit it
>> and click the filter tab. In the expression enter the value formula then
>> us e the top N in the formula column, and =10. That just worked for one
>> of my charts. If you have any problems i will explain it better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>|||I have a report that does the exact same thing. I still couldnt get it
quite perfect but i did narrow it down by setting a filter on the chart that
said my value needed to be greater than a specific amount and that took some
off.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:uF5ETCf0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Ben, I am SUCH an idiot.
> Your advise is flawless and what you state is correct. Unfortunately, this
> is what I was doing and wasn't seeing the results I wanted. The reason
> why? Many of my columns have the same value (e.g. 4) so when limiting to
> the top 10, i wondered why I could still see 16+, the last 8 fields were
> all the same value.
> I wonder if this should be happening. I would like to purge my set to
> exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
> filters on date?
> Taz
>
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> Let me try to explain again. Put your sum or count formula from your
>> value field into the expression column. Use the Top N from the operator
>> column and put =10 in the value column. DO all of this in the category
>> group that you want filtered.
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit
>> it and click the filter tab. In the expression enter the value formula
>> then us e the top N in the formula column, and =10. That just worked
>> for one of my charts. If you have any problems i will explain it
>> better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below.
>> What would you suggest? How can I use the TOP N syntan on an aggregate
>> field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am
>> I missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>>
>
Is there a simple way to limit the number of bar that are drawn? I.e. I only
want say the top 10 bars showing. My dataset is large and displayed 300 bars
is too much/a mess.
I dont want to filter the dataset, as the bars are constructed from
aggregate data (sums and counts). I do not see a simple limit, or am I
missing something?
Any tips appreciated!
Kind regards
TazYou can use the TOP(N) on the dataset then link ht echart to that dataset.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
> Hi, I have a chart control that is working very nicely indeed.
> Is there a simple way to limit the number of bar that are drawn? I.e. I
> only want say the top 10 bars showing. My dataset is large and displayed
> 300 bars is too much/a mess.
> I dont want to filter the dataset, as the bars are constructed from
> aggregate data (sums and counts). I do not see a simple limit, or am I
> missing something?
> Any tips appreciated!
> Kind regards
> Taz
>|||Hi Ben, thanks for the response below.
I have tried this and am having problems, please see my post below. What
would you suggest? How can I use the TOP N syntan on an aggregate field?
Thanks
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
> You can use the TOP(N) on the dataset then link ht echart to that dataset.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>|||go to your category group in you chart that you want to limit and edit it
and click the filter tab. In the expression enter the value formula then us
e the top N in the formula column, and =10. That just worked for one of my
charts. If you have any problems i will explain it better.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
> Hi Ben, thanks for the response below.
> I have tried this and am having problems, please see my post below. What
> would you suggest? How can I use the TOP N syntan on an aggregate field?
> Thanks
> Taz
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and displayed
>> 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>|||Let me try to explain again. Put your sum or count formula from your value
field into the expression column. Use the Top N from the operator column
and put =10 in the value column. DO all of this in the category group that
you want filtered.
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
> go to your category group in you chart that you want to limit and edit it
> and click the filter tab. In the expression enter the value formula then
> us e the top N in the formula column, and =10. That just worked for one
> of my charts. If you have any problems i will explain it better.
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e. I
>> only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>|||Ben, I am SUCH an idiot.
Your advise is flawless and what you state is correct. Unfortunately, this
is what I was doing and wasn't seeing the results I wanted. The reason why?
Many of my columns have the same value (e.g. 4) so when limiting to the top
10, i wondered why I could still see 16+, the last 8 fields were all the
same value.
I wonder if this should be happening. I would like to purge my set to
exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
filters on date?
Taz
"Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Let me try to explain again. Put your sum or count formula from your
> value field into the expression column. Use the Top N from the operator
> column and put =10 in the value column. DO all of this in the category
> group that you want filtered.
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit it
>> and click the filter tab. In the expression enter the value formula then
>> us e the top N in the formula column, and =10. That just worked for one
>> of my charts. If you have any problems i will explain it better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below. What
>> would you suggest? How can I use the TOP N syntan on an aggregate field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am I
>> missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>|||I have a report that does the exact same thing. I still couldnt get it
quite perfect but i did narrow it down by setting a filter on the chart that
said my value needed to be greater than a specific amount and that took some
off.
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:uF5ETCf0GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Ben, I am SUCH an idiot.
> Your advise is flawless and what you state is correct. Unfortunately, this
> is what I was doing and wasn't seeing the results I wanted. The reason
> why? Many of my columns have the same value (e.g. 4) so when limiting to
> the top 10, i wondered why I could still see 16+, the last 8 fields were
> all the same value.
> I wonder if this should be happening. I would like to purge my set to
> exactly 10, not 12, 13 etc etc. Any ideas? Possibly a second filter that
> filters on date?
> Taz
>
> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
> news:%23Bx$v0e0GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> Let me try to explain again. Put your sum or count formula from your
>> value field into the expression column. Use the Top N from the operator
>> column and put =10 in the value column. DO all of this in the category
>> group that you want filtered.
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:uEOrEye0GHA.1256@.TK2MSFTNGP04.phx.gbl...
>> go to your category group in you chart that you want to limit and edit
>> it and click the filter tab. In the expression enter the value formula
>> then us e the top N in the formula column, and =10. That just worked
>> for one of my charts. If you have any problems i will explain it
>> better.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:OMNq%23re0GHA.5100@.TK2MSFTNGP05.phx.gbl...
>> Hi Ben, thanks for the response below.
>> I have tried this and am having problems, please see my post below.
>> What would you suggest? How can I use the TOP N syntan on an aggregate
>> field?
>> Thanks
>> Taz
>> "Ben Watts" <ben.watts@.aaronnickellhomes.com> wrote in message
>> news:%23FmNoPe0GHA.5072@.TK2MSFTNGP03.phx.gbl...
>> You can use the TOP(N) on the dataset then link ht echart to that
>> dataset.
>> "Tarun Mistry" <nospam@.nospam.com> wrote in message
>> news:ek8ifXd0GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Hi, I have a chart control that is working very nicely indeed.
>> Is there a simple way to limit the number of bar that are drawn? I.e.
>> I only want say the top 10 bars showing. My dataset is large and
>> displayed 300 bars is too much/a mess.
>> I dont want to filter the dataset, as the bars are constructed from
>> aggregate data (sums and counts). I do not see a simple limit, or am
>> I missing something?
>> Any tips appreciated!
>> Kind regards
>> Taz
>>
>>
>>
>>
>
Subscribe to:
Posts (Atom)