limit of just 19 selections for graphs.. any workaround?

  • Thread starter Thread starter niels007
  • Start date Start date
N

niels007

Hi all!

This time I know what to do and how to do it but Excel isn't reall
working with me.

I'm making a 'year review' sheet for use in a (computer)store. So ther
is daily input of sales and margin, from which I generate some nic
graphs showing weekly results.

Now I want to make graphs of all the mondays, 52 in total. (and o
course tuesday .. saturday as well..)

week 1 monday result is in A4
week 2 monday result is in A14
week 3 monday result is in A24

Making the graph I select A4, press control and select A14, A24 et
etc, works fine but I can only select 19 individual cells, and i nee
52! It just clears the selection if i continue to click cell nr 20.

Since the space between the cells is always 10, isn't there a way t
say 'just add 10 until you're at A524' or something?

regards

Niels Heusinkvel
 
You could link all the cells to a range of contiguous cells, then create
the chart from that range.
 
Back
Top