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 wrote:
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

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

Perhaps a pivot table?

Examples and links:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"porridge" wrote in message
ups.com...

porridge wrote:
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

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