Excel question

[Trader]

=now() will include the time (which you can remove by formatting the cell).
=today() will give you just the date.

[mickey]

Is it possible to have a line graph over top of a column graph at all using excel 2007

Similar to this

[smac]

http://peltiertech.com/Excel/Charts/ComboCharts.html

That's one site - google "combine bar and line chart excel" for a stack of sites with how-to guides.

[mickey]

Thanks smac, i tried that link but it was like i was reading ancient Mongolian..lol

http://blogs.office.com/b/microsoft-exc ... -axis.aspx

i found this Very Very Very easy to follow and had what i wanted in 5 minutes



Although the line part of the graph is the P&L of our punting club so far this year and its heading in the wrong direction

[Punk Rooster]

In a shared drive environment if a person goes to open an excel file that is already open by someone else, it comes up "read only" and that person cannot update and save the document.

Is there anyway to amend the excel file so this doesnt happen, so multiple people can access the file at the same time, edit it and save it?

If not possible its fine, just thought it might be?

www.dropbox.com

[smac]

In the review tab, turn on file sharing.