Excluding certain rows from being included in diagram

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a table (from which I produce a number of graphs)
that begins as follows

Order No. Requote Change Requote
280
280 A
280 A B
280 A B C

For every order made there is a possibility of a re-quote
being made before the order is sent out. This will be
entered on a separate line but the Order No will remain
the same. I need to chart this information in a bar chart
but I want to exclude any lines where a re-quote has been
made in order to avoid duplication of data.
New Orders will be entered onto the 'Order log' as the
next number e.g. 280...281...
If we have to re-quote then a new line should be inserted
and the Number becomes 280 A, B, C (this would equal 1
original [280] and 3 re-quotes [A, B and C]).
The graphs should only plot the data for the original
Order entered and should not include Re-Quotes and Quotes
for Changes or Quotes for Spares.
I would be grateful for any help anybody might be able to
offer.
Thanks
 
Alan -

By default, Excel only charts data from rows/columns which are visible.
If you hide the rows you don't want to plot, they will not appear on the
chart. You can either hide them manually, or set up an autofilter of
your data, and probably hide all nonblanks in the first Requote column.

- Jon
 
Back
Top