In this article, we will learn how we can perform the function of sizing the chart with the Zoomin Microsoft Excel 2010.Before sizing the charts with the window, we need to create a chart.
Charts option contains 10 types of charts that include Column, Line, Pie, Bar, Area, XY (Scatter), Stock, Surface, Radar, and Combo Charts.We can create chart by pressing the only one key on the keyboard.
We have data in the range A1:B13 in whichcolumn A contains Month and Column B contains Achievement.
We want to create a chart by using the F11 key, follow below given steps:-
For sizing the charts with the window, follow below given steps:-
This is the way we can adjust the chart size with the Zoom in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
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.
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. 1) Using VBA to pick up the last (or next) number to be used, inserting it in your document, and then incrementing the counter. 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
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.