Graphs and Storing Input Data and Outputs | Excel forum

Resolved · Medium Priority · Version 2007

Tue 6 Dec 2011, 16:13 Delegate Ioanna said...

Ioanna has attended:
Excel VBA Intro Intermediate course

Graphs and Storing Input Data and Outputs

I would please like to know more about:
(1) creating charts
(2) ways of storing input and output data separately when i'm using an excel workbook as a calculation tool. the aim of this would be to keep the size of the tool small and to keep a record of input and output data for future references. also, could these be automatically stored into an access database? is this the best way to store input and output data after they have been used/produced?
Thank you!

Fri 9 Dec 2011, 10:29 Trainer Simon said...

RE: Graphs and Storing Input Data and Outputs

Hi Ioanna,

Thank you for your question and welcome to the forum.

Please find some chart code attached to this email which will help you.

I will pass the second request to a colleague of mine who will be in a better position to assist you.

Regards

Simon

Attached files...

Outlook word and chart code.doc

Fri 9 Dec 2011, 12:44 Delegate Ioanna said...

RE: Graphs and Storing Input Data and Outputs

Hello Simon,

Thank you very much for such a quick and helpful response. I'll have a go!

Regards,
Ioanna

Mon 12 Dec 2011, 09:48 Trainer Anthony said...

RE: Graphs and Storing Input Data and Outputs

Hi Ioanna, thanks for your query. Automatically storing the input and output data in an Access database is certainly possibly but a bit involved. It not only involves coding the connection to the database but also attaching that to the Worksheet_Change event of the spreadsheet itself. We cover material of this nature on our Advanced Excel VBA course and a conversation about what you want to achieve would be a good idea then.

Hope this helps,

Anthony

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips