hi there,
I have a bar chart that looks at 100 rows i.e.: the source data.
This data is sorted from the top largest to the bottom smallest. I pick the top 50 rows of the 100 for the bar chart graph.
Can the bar chart function look at the 100 rows, and just output the top 25, and bottom 25 in the chart i.e: ignore the data in the middle.
The source data changes all the time.
Do I need to go into excel and manually delete the rows, then sort the date; so i generate the chart with top 25 bottom 25?
Any ideas very welcome
A
[/code]
I have a bar chart that looks at 100 rows i.e.: the source data.
This data is sorted from the top largest to the bottom smallest. I pick the top 50 rows of the 100 for the bar chart graph.
Can the bar chart function look at the 100 rows, and just output the top 25, and bottom 25 in the chart i.e: ignore the data in the middle.
The source data changes all the time.
Do I need to go into excel and manually delete the rows, then sort the date; so i generate the chart with top 25 bottom 25?
Any ideas very welcome
A
[/code]