Hi, thanks for the promt reply. In the report there are a possibility of 19
column headings but depending on the selection criteia the number will vary.
All the blank rows will be at the end and I wish to eliminate them to ensure
they do not appear in the graph.
Davie
"Don Guillett" wrote:
Do you know which columns. Are they together or at the start/end of the
data?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"davethewelder" wrote in message
...
hi, I have a spreadsheet with 20 columns but the report which supplies
this
spreadsheet will supply less than the 20 coumns of information. I want to
graph this data but I cannot figure out how to hide the blank columns.
Can anyone help?
Cheers,
Davie