Search:

Hi Steve,

I happened to see a Box and Whisker Graph on the net. I did try creating one and was successful. However I am unable to put the existing ranges on the graph. Are you able to help me in...

Hi Steve,

I am back with a query on the graph that you created for me. I was trying to re-create the graph for another set of data. While I am able to create the graph I am unable to get the...

Hi Steve,

Thanks for the solution, I would prefer it the ways you have done it for me. I just wanted to check if the Company Midpoint and Survey Midpoint could be parallel so that visual...

HI Steve,

I was able to figure out why the line was appearing. It was a problem with the range. I has been fixed now and is working perfectly.

I wanted to know if it is possible to have the...

Hi Steve,

Not sure if it is a problem with excel on my system. I can acutally see those line on the chart sheet of the attachment in the post. I have taken the screenshot of the same and pasted on...

HI Steve,

Thanks for this. However there is this red line that is showing up as line graph apart from the box. Need to remove that. How do I do it. Im not sure if it is the problem im opening the...

Hi Steve,

I am revisiting this post again. You had provided me the vertical band based on min and max salary range and the points min and max.

Now I have the actual salary of the employee...

Thanks Rory, It works perfectly

Hi RG,

Thanks for the formula, its working perfectly. I also want to know if we could you the same logic for AVERAGE.

Regards
Baiju

Hi,

I have an excel report, I have used if condition to give me a #N/A if the cell value is 0. I if SUM the range i get #N/A. Can you please let me know a formula that will SUM excluding the #N/A...

Hi Steve & TD,

Thanks for the formula, it did work for me.

Regards
Baiju

Hi,

I would like to apply conditional formatting for a cell whose formula result is #N/A. I have tried options like if cell = NA() and if cell = #N/A. Both dont seem to be working.

Regards...

Hi Experts,

Is it possible to create a Wagon Wheel chat in Excel? Tried searching on net could not find any. I have attached a picture of a Wagon Wheel chart

Regards
Baiju

Hi Andrew,

Thanks for the, this is working perfectly. Just a couple of queries.

How do i modify the macros if i need to change the graph type?
If I protect the workbook and click ont he...

Hi,

I have a table with with following columns
Column A : Week
Column B : No of Cases
Column C : % with SLA

I have created a Line and Column on 2 Axes graph for the same. I am check is is...

Hi Excel Experts,

Our financial year is Oct-Sept. I have been consolidating and reporting data based on this year on year. Now I would like to have a seperate worksheet that I could use to do a...

Hi,

I found the answer in one of the earlier threads.

Thanks
Baiju

Hi,

I have an excel sheet with dates in one column. This is for me to track and remind.

I would like to colour the cells with three different colour. If the date is before today Colour 1, if...

Yes steve that is what i intend to do. I was just wondering if this could be done through formulas or macro.

Thanks
Baiju

Hi,

I have an excel sheet that has many hyperlinks, this has happened due to copying and pasting by various individual onto the same sheet.

Is there a way of removing all the hyperlinks on a...

Hi Excel Experts,

I extract data on a monthly basis and prepare report. The data sheet has the country(col A), name of the agent (Col B) and order date(Col C). I have used the networdays formula...

Thanks Rory.. this is great you have made my job easy

Hi Rory,

As you suggesting that i write a macro. Im not good at macros.

I am attaching a excel file with two sheets one has the report the other the graph. I also have a drop down in both...

Hi Excel Experts,

I am tracking the productivity of my employees and i have prepare a report for the same. with the list under data validation with the list of employees. I have also created...

Hi Geof,

Thanks for this. I was able to get build a formula based on this, however I am faced with the challenge with the leaves of the employee. I also want the formula to be able to let me...