Selecting many specific columns for a chart

  • Thread starter Thread starter porridge
  • Start date Start date
P

porridge

Hi all,

I have two questions:

I have daily sales figures for a shop for the last 6 months.

I'm happy with the charts which I've produced but I really want to
produce charts which show the average sales figures for each day of the
week.

So I want a bar chart to show the average Monday turnover, average
Tuesday etc etc.

Please could someone tell me a short cut so that I can select every
column which has a Monday heading or a Tuesday heading etc etc without
physically highlighting every Monday in the last 6 months?

Secondly, within a few weeks I will run out of excel columns (I'm up to
IV) can someone please tell me how to extend Excel so that it will go
on indefinitely or is that not possible.

Thank you
 
porridge said:
Hi all,

I have two questions:

I have daily sales figures for a shop for the last 6 months.

I'm happy with the charts which I've produced but I really want to
produce charts which show the average sales figures for each day of the
week.

So I want a bar chart to show the average Monday turnover, average
Tuesday etc etc.

Please could someone tell me a short cut so that I can select every
column which has a Monday heading or a Tuesday heading etc etc without
physically highlighting every Monday in the last 6 months?

Secondly, within a few weeks I will run out of excel columns (I'm up to
IV) can someone please tell me how to extend Excel so that it will go
on indefinitely or is that not possible.

Thank you
Click to expand...

Sorry all - I'm bumping this up in the hope that someone can give me an
answer to at least one question!
 
Back
Top