Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Need help with date-time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sean - 06 Jun 2007 06:28 GMT
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 - 06 Jun 2007 09:02 GMT
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?

Signature

HTH

Bob

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

> Hi all,
>
[quoted text clipped - 16 lines]
>
> Sean
Sean - 06 Jun 2007 11:04 GMT
> Sean,
>
[quoted text clipped - 6 lines]
>
> Bob

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 - 06 Jun 2007 12:24 GMT
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.

Signature

HTH

Bob

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

>> Sean,
>>
[quoted text clipped - 22 lines]
>
> Sean
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.