Search results

Hi I recorded my actions using the macro recorder, and that was the code it gave me as an output. I'm copying a legend, which is actually just an image, from one set of panel charts that share this legend, to another workbook with the same panel chart layout and series but different data. The...

Hi I tried it, and exchanged the sheet1 to simply (1), as that's all my workbook/s have. But it gave me an error message on the part: SO.Shapes.Range(Array("xlamLegendGroup")).Select Saying the item with the specified name wasn't found I'm wondering if just from looking at it whether it's not...

Hi I've recorded myself copying a legend from my correct workbook (Mike1) into another one (OtherWorkbook) that I have opened. I'll be doing this process quite a few times so wanted to make a short macro to help me do this. Unfortunately, the 'OtherWorkbook' name is very specific, and I can't...

Thank you Narayan, I'll have a look into the additional column (hidden obviously). Best Mike. [Update] It worked a charm. I simply added 100% into one cell next to my top row of numbers. Selected the whole range and then chose data bars. The formatting/length of the bars was correct 50.4% was...

Hi My question is: Any ideas what I would need to change to make the conditional format data bar size represent the cell number compared to 100%? Rather than compared to the highest number in the range of numbers? I was trying to make a table full of numbers look more...useful. So I thought I...

Hi Luke. I've used your amended original code and it works great. It's done exactly what I tried to explain. I didn't try your alternative code because I fear it's actually looking for a table heading (.SpecialCells), whereas the files I am working on have make-believe headings, as they are...

Hi Luke. Yep, it was something. I simply pasted your code in and ran it. Unfortunately there are some strange outcomes. I've uploaded a file I ran the macro on, and highlighted (yellow) where it pasted the values, compared to where I thought it would (green). I also received this...

Hi I'm updating multiple sheets that contain the same structure - 4 tables, one below the other, numbered rows from 50-250 and 7 columns. Above each table is a slightly different title, but each table has the same column headings. (see attached file) I had recorded myself using the find and...

Narayan. Wonderful. It does exactly what I was failing to do. Looking at how you've done it I realise that my aspirations were well above my abilities. Thank you so very much. And also a big thanks to Chandoo's forum. Mike.

Hi Narayan Nailed it. As both tabs are the same structure I only highlighted the first one. I'm looking to find the number 14 in Column A and use the row it is in to help me make a selection that goes from $C$5:$F[Number 14 row number]. I have a macro that already does everything I need it...

Hi Narayan I've attached a file. You'll see I've highlighted the condition in column A (number 14) that will allow me to use that specific row number to create an appropriate range (yellow cells). This range would then be formatted with a certain number format. This number format can only...

Hi I'm working through multiple, and slightly different sheets, and trying to select a range based on a condition in a column that will not be part of the final range. I would then format the numbers within my final range. Column A = contains number "14". (Row n) Final range = $C$5:$F(n)...

Thanks Colin. I was wondering why a simple ',' would cause the problem.

I think I cracked it. I needed to remove the stray ', ' in the first part of RIGHT(L13,).

Hi I've a list of country names with * at the end of some them. This list is generated each year, and some country's lose the * depending on the year. I'm going to extract data from each year using INDEX/MATCH so I need to remove the * at the end of each country. I've found and tried this...

@Vijay Sharma Many, many thanks. For my needs I've chosen Connect with line, but that hidden gem is one to remember. Therefore I've copied and pasted you answer into this one so people can see what the answer was. Select you chart On the ribbon > Design Tab (under Chart Tools) Click on the...

@Luke M. That sounds simple...but I'm struggling in Excel 2007 to find the options you have mentioned. After the chart is selected I have the basic ribbon options of Design/Layout/Format. Where does it come under this? Thanks Mike.

Link below to the data. It's in Google Docs. It did have an example of the X-Y scatter chart, with it's gaps, but that's been removed for some reason. Anyway, if you create an X-Y you'll see that the lack of data in all years means there are gaps. Any advice on how to add the lines between...

I've tried both types - line and X-Y, and the same problem persists.

Hi I'm trying to figure out how to make an X-Y Scatter include a line between data points even if they are far apart - 5, 6, 7, 17 , 29, 32... I have a dataset that has products sold over years. Unfortunately, there are missing data points for some products over a number of years, i.e. 1965...

UPDATE - found the answer: Realised that I should have been using * and not /. The formula now contains...W$3*50,1...and I'm seeing results. Thanks mike.

Hi I was reading, and now implementing, the article about improving in-cell charts with negative values. I've run in to a problem. When I apply the formula used in the downloadable sheet, it does not show up my small % values. I've therefore tested with some other % values and only begin to...

This sounds very interesting. Is it something that is 'commonly' used for such circumstances? When you mention the second chart not having a Horizontal axis, how is that created? I'm not sure how a chart is built that doesn't have both axis? I'll look in to it, but if you happen to know...

Hi Apologies for the cryptic title. I'll try and explain. I have a lot of line graphs that I need to compare against each another. I have a common scale used on all (see my MAX/MIN question) and it's really helpful. However, the graphs have a lot of their data stretching along the...

Solved the Horizontal Axis problem. Remove the tick when pasting in the MAx Min from the Category X label option. Mike.