Free Microsoft Excel 2013 Quick Reference

Ajusting a ChartArea's size

Hi !
Here is my question:
I am adding a graph(line chart) as a new Excel-sheet, and wanting to
enlarge it's size.I think the ChartArea should be set like that:
With ActiveChart.ChartArea
.Width = 800
End With
It might work as the graph is set in a data sheet, but when it was set as a
graph sheet , it doesn't work.
Error message is that "runtime error 1004 ",and it sais that ChartArea
Class's width can't be set and it considered as read-only.
I'm so puzzled and would like you to help me with it.
If my method is wrong, any good ideas?
Thank you very much !

Post your answer or comment

comments powered by Disqus
Intend to check out a file size throught VBA .. is it possible?

if the path is c:abc.txt
how i can know the file size of abc.txt via vba code?


Is there a way to fix the footer information so that it remains a constant size on each worksheet regardless of how you have had to adjust the page set up to ensure the data fits on 1 page. ? I am finding that where i have had to shrink to fit some pages it reduces the visual size of the footer information even though the margin size remains unchanged



Sorry if this question has been posted before. I couldn't find it.
I'm making an Excel graph based on a Sql query I run and shows in a different worksheet. My problem is that I get different amount of result each time the query is run but my graph is always of a fixed size. If I set the data range of the graph as something huge I get a bad looking graph.
How can I edit the graph so that it has a big data-range but only shows cells with data in them ?


Is there a function to find out the size of a variable size array ?


How to define a variable-size area in a time-series chart-creating macro that
would include all the data in a worksheet, starting for example from cell B6?
RyGuy suggested using

Sub Ender()
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
End Sub

but how to include these values in the chart-creating code instead of the
direct "B6:E100" address in the example given below?

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=Sheets("Data").Range("B6:E100")
ActiveChart.Location Whe=xlLocationAsObject, Name:="Data"


Ok. Since I could not get the "insert-pictures-from scanner" thing working(see other posts I made), I am trying this.

Private Sub CommandButton2_Click()
Shell ("c:windowssystem32wiaacmgr.exe")
End Sub
It works fine and opens up the scanner wizard. I am wondering if there is a way to "customize" the scan to always scan a letter size page and always in b&w. Also, is there any way that it could save the picture on the worksheet that initiated it, rather than having it default to my pictures?

As always, thanks for any help in advance!

I have a spread sheet full of data. I need to incert a larger sized, blank
row in every other space? Macro possible. I have this macro:

Sub test()
Application.ScreenUpdating = False
Dim numRows As Integer
Dim R As Long
Dim rng As Range
numRows = 1
Set rng = ActiveSheet.UsedRange
For R = rng.Rows.count To 1 Step -1
rng.rows(R + 1). Resize(numrows).EntireRow.Insert
Next R
Application.ScreenUpdating = True

This will add the row, I just need it to be a larger size.



I would like to create a custome size worksheet (11inches H x 17 inches W in excel (2007) can anyone help? Thank you

I have a series of spreadsheets that in view mode take up approx. 58 pages.
Need to make a presentation, and interested in there is an option to
display/print a speadsheet on a poster sized document.

How can I get the WORDART TEXT to fit in a smaller size TEXTBOX in a circular alignment?

I am trying to get the Formatting present in a MS Excel WordArt which can be compressed to a smaller size of 12-14 pts and tilt to an angle similar to a semi-circle

How can I get this, any suggestions please!
Also, I am tring to put text over an Image to make it more Authentic.. so need the TEXT to be a curved angle like the letter "U" inverted and the angle slightly wide

After making changes in an Image in Excel how do I save it in a Folder as after Copying I cannot Paste it in a FOlder, whats the procedure for saving an Image created or Modified by a user?

Warm regards

How to get a Watermark with a particular Size,Font and Colour?

Dear Forum,

I may be asking a very simple query but am going nuts over this, I am trying to replicate an Income Tax Document for my records and have manged it quite succesfully except for the WaterMark..

The text in the WaterMark is as follows"

I need the above TEXT alongwith the pair of double-quotes in the beginning and end to be in the Colour Silver Grey and the Font "TIMES NEW ROMAN"

When I am trying to get this done from the Insert WordArt ,
I am not getting any options to customise.?
And moreover its not even a Watermark, it stays in the front..

SO is there a way around this?


Hi guys,

I have a data set that looks like this.

Score -----6.51----6.72----7.85----8.21
base size ---40------80-----100------25

That is one question, I have about 100.

I need to highlight the largest mean Score that has a base size greater than 30. In the example above "7.85" would be highlighted. Not 8.21 because the base size is less than 30.

Does anyone know how to do this? It seems simple enough that I shouldn't have to write a macro to do it.

Any help is appreciated.


I have spent the better part of the day trying to figure out the following - I know the title doesn't describe the problem well.
What I am trying to do, is make a "summary table" that compiles information from several categories into one, but to allow for the table to dynamically update (data and size) as the data change.

Here is a generic example of what I am trying to do:
* Consider 4 categories (blue, green, red and yellow). Each category has a variable number of data in it - no more than a 100 per category.
In the data entry sheet, I have apportioned 100 rows for each category (the blues are int the 100s, the greens in the 200s, the reds in the 300s etc). Any unused rows, are left blank, as they may be populated in the future.

In other words:

RowNum *Category* *Points*
2 Blue 11
3 Blue 32
4 Blue 26
5 (Blank)
6 (Blank)
99 (Blank)
101 Green 9
102 Green 45
201 Red 14
202 Red 39

and so on and so forth.

What I am trying to do is create a dynamically contractible/expandable table that shows:

*Category* *Points*
Blue 11
Blue 32
Blue 26
Green 9
Green 45
Red 14
Red 39

but that can accommodate the later addition of new category data. Ideally, the table size would be defined (on the fly) by the count of non-blank rows in each category, and would present the data contiguously.

Any thoughts would be much appreciated.

I have a drop-down list that displays at about a size 6 (or smaller) font when the worksheet is displayed at 75-100%. I can make it readable by changing the magnification of the sheet to 150-200%, but that takes the rest of the sheet out of view, interferes with functionality, and is just an all-around pain in the butt. How do I format the list to make it display at a readable size?

I'd like to create a worksheet page which is, quite literally, only A4 size. I don't want to have any more cells to the right of the page or on the bottom (and so take the sheet onto another page)

Correspondingly, if I change the size of any cells then I don't want it to make the page bigger .... I want it to make the other cells smaller to compensate.

I'm sure you know what I mean....... but I just can't see how it's done.

Can someone tell me what it's called and maybe how to do it quickly?


I want to calculate how many bytes in one sheet, the size of a excel
file(in bytes)
Is there any functions to get them?

Message posted from

Driven mad by having to resize pivot tables constantly, printing and
reprinting to ensure they fit to a page and are readable. There needs to be
some way of setting the actual print size so that you can read its printed
format in the size that it will be, with a view on how much outside of the
print area you are in relation to the actual size of a page.

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane. unctions

Is there a way to force a shared workbook to always open in a smallish size,
window ie, maybe 6" square, for all users?

The idea is to use a hyperlink on the primary worksheet to display a lookup
table in a second worksheet (like a popup help window) without completely
blotting out the primary worksheet.

The worksheets I work with have a variable number of columns and rows, thus
when I record a macro and use a Ctrl-Shift-End to highlight an area to copy,
it may/will not work if re-used with a different set of data. This is
because the macro records an absolute address of the lowest rightmost cell,
not the Ctrl-Shift-End operation. Of course, I could always oversize the
area being copied to the largest possible size, but the solution would not
be elegant and probably waste storage space...

What expression/formula should this lowest right address be replaced with in
a modified macro to include only the rectangular area with filled cells?
What if the upper left cell's address is other than A1?


I am copying from Excel and pasting into powerpoint the graphs. I need to
make sure that the size of the graph covers the most of the whitespace
withing the "box" that holds the graph. Is there a way to have the graph to
be set, and not shrink in width?

I am trying to print from Excel 2000 on Win XP to a custom sized card, but
can find no way to specify a specific custom size in Page Setup as was
possible on Win 98. How can I specify the exact size of the sheet that I


I have a header with a font size of 36, that is the result of a couple
of links and would like to add one more item in 14 point font size,
Is it possible to do some kind of TEXT command to change the font of
the last part of this header?

Any help would be appreciated.



I am trying to figure out how to set a default font size for the comments I
add inot my excel worksheets. I have figured out how to change it in the
individual comment boxs but have not been able to find a way to set it to a
default font size so it will always appear in a larger font.

I have an Excel file of 1 worksheet, containing data in about 20 rows by 20
columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
pasting it doubles the file size, but I cannot find anything wrong in those
cells. I tried the following:
1) If I copy all worksheet and paste it in a new worksheet file, the new
file size is the same, > 300kB
2) If I copy and paste all the data column by column, the new file size is
16 kB !
3) If I copy all worksheet and paste values only, the new file size is 14 kB
4) If I delete all the data and the cell formats in the original worksheet,
I still get a large size of > 300 kB !
This is weird. I have nothing in the worksheet, no hidden worksheet, and I
really deleted the rows and columns by selecting them and pressing DELETE.
When I press CTRL-END, the cursor stays at cell A1.

Please help me understand this !


No luck finding an answer? You could always try Google.