Excel charts - give top bottom only while ignoring rest of

[amcurtin]

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]

 

[amcurtin]

Excel charts - give top bottom only (more info)

sorry i was not very clear......

The series in the chart tab is linked as follows:

[/code]=('Chart - Data'!$F$2:$F$25,'Chart - Data'!$F$75:$F$100)

I can split the 100 and get the chart to look at the top 25, bottom 25.
Can i put a line across the bar chart at the dividing point; to highlight that I do not have continuous data.

Can I upload the chart to show you? It will be much clearer?
I generate the files using VBA: paste data, sort data, and point the chart to the first 50 rows of the 100 rows. I use named ranges. Is it possible to to do this using VBA?
A