Search results

Hi listers I have had this problem twice that Excel files reduced to almost half the size. First time from 14MB to almost 8MB (both files in Excel 97-2003). The second time from 8MB to 2.6 MB (this time file saved as Microsoft Excel Macro-Enabled Worksheet instead of Excel 97-2003). The...

Hi listers, This is probably a simple question for many of you. I am working with someone else's workbook and have renamed cells and some names are redundant. So I want to find (and maybe list) all cells that are not used in any formula in the workbook and then delete them. Is there an easy and...

Hi Excel gurus, I have a quick question and would appreciate advice. I have a lot of named cells which I use in different formulae. Every time I want to go to the actual location of the named cell I go the Name Manager and find the named cell and then close it and then go to the location. This...

Hi listers, I am working with Excel 2010. I have used conditional formatting rules using simple formulae and a specific RGB color format (to define red, green and amber colours). However, when I sent the file to my colleague, it was all in one colour. Can anyone suggest a solution to this...

Hi colleagues, I am struggling with perhaps a simple dashboard question. I am trying to replicate bar charts in KPI dashboard - revisited II (available on chandoo.org). My minimum value and first quartile are below zero while median, third quartile and max are positive. I also have a target KPI...

Hi listers, I know I can paste from powerpoint and keep the formatting but the column width is all over the place and I need to change it manually for each column. Is there a quick way to import table as it appears in powerpoint (not as an object or picture)? Thank you

Dear listers, I would appreciate help with this. I have added an upward/downward arrow in a cell using an Excel symbol. I would like the height and fatness of the arrow to change with the value of a cell. So if say the value of cell A1 changes from 10 to 50, then I would like the arrow to...

Hi listers, I want to include a box (or a cell) in my front sheet so the user can specify the zoom level for the entire workbook. I have come across the following macro which lets you zoom to a specified percentage but not exactly what I am looking for. Sub SetZoom()Dim ws As Worksheet...

Hi, I need a macro that does the following (and would appreciate your help): 1. MsgBox saying "Your choice means ..." and in place of ... I would like the value in a particular cell. 2. Then I would like Yes and No options to appear below the above text in the message box. If you click No...

Dear listers, I need to a macro (or a different solution) whereby all my sheets go on full screen view. Perhaps I can have the macro on the front sheet and then all sheets are visible in full screen mode. That would be really appreciated. Thank you! ExcelStuff

Dear Experts, I am using a slider to change values in a particular cell. Now depending on the value in the cell I would like to show shapes next to it (in a text box or cell or whatever). So for example if cell value is 10, I want to show a 5 green triangles, when its 8 then 4 triangles etc...

Hi, I have two categories (say group A and B) and relevant numbers for each category. I am using a slider to change these numbers. Then I use a 3D pie chart to represent share of each group in the total pie. Now what I would like is that the pie should do two things: 1. The overall size of the...

Dear listers, I have several graphs on one screen and I want to be add a button or tab for which graph, so the user can click on it to show the graph and then click again to hide it. Can you advise on the best way to do this please? Thanks S

Dear users, I have a bar graph with a huge blank space on the right side. This happened when I moved the legends to the bottom of the graph. Obviously, resizing the graph doesn't help in anyway because it shrinks the whole graph. I would appreciate any advice. Thanks S

Hi, I have a bar graph which takes values from a slider. What I need is to show is that values below zero in the bar graph should be in red and above should be in green. The challenge is that as the slider moves, the values change (as above or below zero) and I want them displayed in different...

Hi, I have made several comments in a large Excel file and want to list them all in one sheet with sheet and cell references. Is there a way to do this? Many thanks

Hi, I want to change the vertical axis title of a bar graph from two lines to one line. Yes, I did change the font size but it has to be very small to be in one line (which is understandable). However, I noticed that in some charts the title was two lines long and in others it was one line...

I am working with a bar graph and want to add an additional side label on the side of each bar to represent how much the value has reduced compared to the previous graph. Hence, the value in the side label will be equal to a formula. Is this possible to do in Excel? Thanks.

I am using a bar graph and have selected the data labels to appear at the 'outside end'. However, I want to control the distance between the bar and the data label. Is it possible to do this? The vertical alignment option doesn't help much. Much appreciated.

Hi, I am using a bar graph and want to be able to set the minimum and maximum values and major and minor values equal to a value defined in cells so I don't have to change the axis every time. Any thoughts? Thank you!