Need help with date-time

[Sean]

Hi all,

I have data that varies on a daily basis. There are three series of
data - sales, productivity and refunds. For every series there's
multiple data for each day. For example, on Monday 7th June there are
three sales figures 10, 20, 30; three productivity figures 10%, 20%
and 30% and three refunds worth $5, $10, $15. The data is entered on a
daily basis.

I want to create a chart that shows this detail on a daily basis i.e.
on the X-Axis it should list date and for each date it should plot the
values for those series. I have already created a chart with the three
series however I have not been able to get the dates on the x-axis.

Please help. Any help or pointers in this matter would be greatly
appreciated.

Cheers

Sean

 

[Bob Phillips]

Sean,

I have just knocked up a simple demo where the dates show along the X axis
just using the basic wizard. Can you post your workbook to a temporary
website for us to look at?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sean]

Sean,

I have just knocked up a simple demo where the dates show along the X axis
just using the basic wizard. Can you post your workbook to a temporary
website for us to look at?

Thanks for your reply Bob. I do not own a website so I have uploaded
to Megaupload.com...here's the link to the file:

http://www.megaupload.com/?d=1EAUBBTH

Sheet 1 is meaningless. Sheet 2 contains data. Sheet 3 contains two
graphs.

I know it's a bit of a mess but I hope it's clear enough to understand
this problem. Thanks.

Cheers

Sean

 

[Bob Phillips]

By the cringe, that is an annoying site is it not?

I guess the problem is the layout of the data. To get what you want, I think
you need to tabularise the data differently, with day alongside every item.
I also think you need proper dates, not just day names, you can always
format as day names.

IMO, the best way is to hold the data in a structured table, and then have a
view that is formatted in any presentational style.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)