|  

» Sizing Charts with the Window in Microsoft Excel.

Select a chart sheet (if you do not have a chart sheet in your workbook, press F11), or select a chart that is embedded in a worksheet. From the View menu, select Sized with Window. The chart will automatically adjust to the size of the window.

Rate This Tip
12 34 5
Rating: 3.16     Views: 35943
Sequential Number
JJ  Posted on: 31-12-1969
Hi - is there anyway I can create an excel Template, it may be an invoice
quote letter etc. What I need it to do is generate a sequential number
somewhere, eg: say 1000. When I open that template again - I want that
number to be 1001. It doesnt really matter if I dont end up saving that one,
and close it so the next person to open that template will be 1002. As long
as no number is repeated.
Reply: Sequential Number - JJ from Australia wrote on July 12, 2003 4:34 AM EST
Alan  Posted on: 31-12-1969
Hi JJ,

Yes - you can do this, but how you do it depends on how many people are creating the documents, and where they are stored after creation.

Your options include:

1) Using VBA to pick up the last (or next) number to be used, inserting it in your document, and then incrementing the counter.

The counter could be in a file on your HDD or network, or even in your registry.

2) You could add a sheet each time for a new document (all in one file), and use a formula to refer to the last document, or even use the MAX function and add one.

3) You could create a new file and pick up the number by linking to the previous file in the same folder (probably).

Lots of options - you need to decide how it would work from a business perspective first, then apply the appropriate technical solution to fit the business process.

Alan.
Creating Charts (150) with Macro
Rose  Posted on: 31-12-1969
I created my macro to extract csv data dump in excel worksheet. TAkes the first two columns copy paste to sheet 1. TAkes those to columns creates chart. How can I go back and play with my macro chart so that it can increase the size of the chart and decrease fonts for better viewing.
Name
Comment Title
Comments