Excel graphing
Discussion
Hi,
Sad b
d that I am, I use a spreadsheet to work out all my monthly incomings/outgoings.
I have a spreadsheet with the last 18 months of finances as sheets.
I'd quite like to be able to see incomings/outgoings over time on a plot graph on a separate worksheet.
How would one go about doing this in Excel?
I actually use editgrid.com as it's available everywhere online but I believe the rough syntax would be the same. Despite working in IT for 10yrs I'm lost when it comes to MS Word/Excel!
Muchos gracias!
Sad b
d that I am, I use a spreadsheet to work out all my monthly incomings/outgoings.I have a spreadsheet with the last 18 months of finances as sheets.
I'd quite like to be able to see incomings/outgoings over time on a plot graph on a separate worksheet.
How would one go about doing this in Excel?
I actually use editgrid.com as it's available everywhere online but I believe the rough syntax would be the same. Despite working in IT for 10yrs I'm lost when it comes to MS Word/Excel!
Muchos gracias!
I don't know how to do it from a code perspective I'm afraid, I'd simply highlight the data range I wished to display and select - Insert - Chart, and the pick the chart type I wanted..
This might give you the clues you need for working it out in EditGrid.com though..
http://www.editgrid.com/explore/tnc/dave/Fusion_Ch...
This might give you the clues you need for working it out in EditGrid.com though..
http://www.editgrid.com/explore/tnc/dave/Fusion_Ch...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


