Excel sales spreadsheet

Has anyone got a formula that shows me a bar chart or whatever of total daily sales over a monthly period using the sl transactions downloaded sheet?

Once you have the spreadsheet, you can create your chart by plotting the sales figures into the axis- Excel practically does it for you- here is a really easy to follow explanation on how to: http://spreadsheets.about.com/od/c/g/chart_wiz_def.htm

I just get a blank square

Perhaps you have no sales . . .

Pep (Couldn't resist it)

I've got 2500 lines of data this month so far so i beg to differ

Mine is a mock up - my sales are non-existent but- one you have the figures down loaded- click the the graph looking icon on the tool bar and it will ask you to plot the axis- then title and you should have a chart - you just choose how u want it to display.

He's just messing with you, Gary -

Is it the chart function is not working for you at all? or you are not getting a good download from the site?

oh i know. i hate smart arse replies that every thread seems to have

it doesnt seem to like the dates and the money one says that it only has 255 lines max

hmm- well not sure u want to trust a stranger to your data- but if you do and want to i wd be happy to take a look for you.

Respectfully, Gary, hit F1 in Excel and read the help for charts. It will explain it.

I thought excel would 'excel' in this easy type of thing.. i only wanna see the totals of daily lindens across a month.

that's why i come on here. i havent got all week to read it. thought it would be something that a lot of people use? maybe not. no worries.

Respectfully, Gary, it is not excel, it's you.

If all you want to see is the total across one month, put in one month's data on one sheet, and then use the formula =sum(A1:A31) in the cell that calculates your totals. A1 and A31 are your row and column numbers. Put in your own.

If you want a chart, read the help. It is more complex.

ooh I am in love with this thread!

I have a project in my class all about Excel and I am not that great with it yet.

ty ty

oh here is what I used to learn the basics.

http://office.microsoft.com/training/training.aspx?AssetID=RC100766511033

Excel is not hard to use. All the frequently used things (sums, charts, tables, formulas, etc.) all have wizards. Mouse over the buttons to see what they do and read the help as appropriate.

excel doesnt recognise the date format. so that doesn't work. and when i put the number into the other axis it says that it's limited to 255 values?

hey guess what, if i was great at excel then i wouldn't have come on here to ask about it.. saying that it's me is bloody obvious. well done. if you have not help other than to state the obvious, then with all respect, don't bother to reply.

At the top, select "Insert". Chart should be listed.

From there you have to assign the rows/columns you want to track.

Just follow the dialog box. It'll walk you thru it.

You might have to change the date format if it doesnt recognize it. Yea, I know its a pain in the ass.

You insinuated that Excel did not 'excel' at the easy things, when it does. Do not come here and bitch about the program when it's you.

aww come on Gary this is a good thread on a public forum ppl are going to reply. Cristalle, has always been quite helpful, imo.
I would hate for this to become another fighting thread.
Excell is rather easy once you go through some tutorials, helped me a bunch.

Ok no worries. i came here for help and as usual it turns into a joke.

you're crap, read the instructions...

that great advice could work for every single thread made... well done.

someone close this thread please. waste of time.

People chill- please!!! There has been all sorts of negativity lately- let's try for a little happydust..please? Gary- I can't IM you you don't have it turned on- IM me with your email addy- I will set one up for you-

No not at all must be a miscommunication.
really the tutorials helped me a lot.

But I must say this makes ppl wanting to answer questions, doubt they will next time.

Enough 'help'

Close The Thread!!!!!!!!!!!!!!!!!!!!!!!!