How can I change the typeface to Times New Roman for all three and change the font size for the Axis titles? hundreds of charts to change and not enough patience to to it manually.
I'm not getting all of my text into the Axis title "box" in a normal graph in excell. And I'm not able to use the arrow to "drag" the axis title to a larger area. Making the size of the text smaller is not a option, I would like the axis title area larger.
I have a created a filter in my workbook. Text for the entire spreadsheet is set to Arial | 12 pt. Font. However, when I select any one drop down list the text therein is shown in a font size that is too small. How can I change the font size to make it more readable?
im using combobox from the forms toolbar. and i have tryed and searched lots of forms and sites but no results, so what im trying to do is change the font size to 12 in my combobox using VBA.
-im using xl2000
-i dont wanto switch to the combox in the active x becouse i have more than 70 comboboxs in this spread sheet. and it will also be very complicated to change the comboboxes due to all the link cell's and there values.
It all works fine but I've noticed an odd quirk which I can't explain nor can I seem to fix. Here's the (reduced) code :
Code: Dim appExcel As Object ' Excel Application Dim chtPareto As Object ' Chart Set appExcel = CreateObject("Excel.Application") Set chtPareto = appExcel.Charts.Add With chtPareto ' Primary category axis
[code]....
The category (x) axis title should be horizontal, whereas the value (y) axis title should be rotated. Stepping through the code, when I .SetElement for the category axis title, it appears horizontal as planned. However, as soon as I .SetElement for the rotated value axis title, the category axis title also rotates.
1) How do make values on x-axis as words? E.g. apples, oranges, etc.
2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.
I'm looking to set up a spreadsheet whereby individuals answer questions and have to format their answer using a particular font, colour, font size and so on. The idea is that I can then compare their answer sheet to a pre completed one using an =IF function and get a total score. The only problem is =if and =exact only lookup cell text/numbers and don't look at how the text is formatted within them.
I have a basic line chart. It was generated without a horizontal axis title, and very little room to add one. When I add one, the chart won't resize for it, and it bumps into the numbers on the axis. How do I get the chart to resize so this axis title fits in nicely. This has proven to be surprisingly difficult. Note also that a lot of options are greyed out that I try, and so far un-degreyable.
We have a lot of charts we want to create in Excel 2007. We have templates created that seem to work. (But also sometime seem to not.)
After the charts are created that are placed in their own chart pages/sheets. The problem I'm having is that the x axis title doesn't seem to be centered horizontally wrt the x axis of the plot area. (It does look centered wrt the chart area.)
Some code or an algorithm to control he placement of the x axis title and maybe center it?
I have my Excel set up for a default font size of 12 point.
I often download CSV data to insert into spreadsheets. It opens in a new spreadsheet, and it's properly displayed in 12 point size. When i copy and paste it into the ultimate target spreadsheet (which is also set to 12 point size) the pasted data shows up as 10-point and I have to change the font size back to 12-point every time.
Why is this happening and how can I avoid that re-sizing that occurs?
This probably sounds really weird, but does anyone know whether the size of the text in Cell A1 on Sheet 1 can be linked to the size of the text in Cell B2 on Sheet 2? Like, when I change the size of Cell A1's text, is there a way to have the size of Cell B2's text change as well?
I currently have an Excel spreadsheet already created. I have added drop down lists using the Validation>Data feature and can get this to create the drop-down box, but the font is unreadable. If I create a new sheet and create the drop-down list it becomes readable. I can't figure out why the first is unreadable due to its small size. I eventually plan to add formulas to calculate how many yes's or no's in a column, but will address that later. I use Excel 2003.
Any way to change the font color of a chart axis when a checkbox is set to true.
let checkbox be checkbox5 and chart be chart5. What I would like to happen is that if checkbox5 is true then the font color of the horizontal axis changed to grey (RGB 166,166,166), if it is false then I would like the font color of the horizontal axis to be black (RGB 0,0,0). I also would like this macro to be run every time the checkbox changes, or the corresponding cell changes to TRUE or FALSE (it is in another sheet, say sheet2). This is the code I have so far but all it is doing is showing the chart as selected and not changing the font color. I would also like it to not physically select the chart, this is for a dashboard so the selecting of the chart throws off some of the visuals a bit, but not sure how to do change the chart values without selecting it.
Is it possible to control the font size in a cell with a sliderBar?. I have a template I use to print labels on cd sleeves and need to change the font a lot. Looking for a fast and easy way,seems like a sliderbar would be easy.
How do you increase the font size of a drop down list in excel apart from zooming in. I have 10 dropdwnbxs each with about 16 items.
Everything works fine but users can not see the contents of each drop down box(fonts are too small). Is there a solution to this? (or just keep zooming in/out). Example i have a drop down box in A2 with source from F2:F17.....etc
I have a simple combo box on my worksheet and the data range is from cells A1:A100 (this is hidden), is there a way to change the font size of the data that populates the combobox? I have tried to re-size the data in my range but this has no effect
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've created a combo box in excel with the macro recorder. This is the code that came back:
Sub test1() ActiveSheet.DropDowns.Add(1305, 52.5, 242.25, 39).Select With Selection .ListFillRange = "$AW$4:$AW$18" .LinkedCell = "$AX$5" .DropDownLines = 5 .Display3DShading = False End With End Sub
This always results in a default font size of 8 for my list. Can anyone tell me how to modify the code above to change the font size to 14? And how to modify the color of the list.
I have executed this macro from this spreadsheet many times but today, after I execute the macro, the box increased in size. I repositioned it on the page, resized it and re-executed. Now it is decreasing the font size within the button each time I execute. It executed just fine yesterday. I assume it's some setting in excel because I've tried another spreadsheet and am seeing the same result.
I'm currently having an issue with Clear All... which sets the font to Tahoma, size 11. Font is okay, but I have my default size set to 10. Everytime I Clear All on even a single cell, the row size increases from 13.50 to 14.25 (from 17 to 20 pixels).
I have a Data Validation list of names but the font is very small and hard to read...is there anyway of making the font larger so as it is more readable.
When a number is entered in cell S3, it triggers formulas throughout the worksheet to populate the it with information from another sheet. If the length of the text in B6 is greater than 80, the font size for B6 only should be 8; if the length of the text in B6 is less than or equal to 80, the font size for B6 should be 10. Regardless of the length of the text in B6, the font size for the rest of the sheet should not be changed.
I tried the following Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address "$B$6" And Target.Count > 1 Then Exit Sub Dim cnt As Long cnt = Len(Cells(6, 2).Value) If cnt > 80 Then Cells(6, 2).Font.Size = 8 ElseIf cnt < 80 Then Cells(6, 2).Font.Size = 10 End If End Sub
