Search results

Hi hi, I want show the achievement against the budget.biker climbs the hill and taking the flag has he achieved

Dear Vietm. I am attaching the sheet what i used .Where i have only one bike which should start from zero to 140.where budget is 100 which has flag and it should pick the flag from budget.

Dear Vletm, This is normal chart which i took from Chandoo.org.However i want to try this as animated chart which i mentioned above.Can you please help?

Hi, This is the excel file which i used.

Dear Experts, I need help on the below. I want an animated chart moving cycle from zero to 140% by achieving the budget [100%]. Bike has to move from zero to 140% by animation cycle moving. Cycle has to pick the flag from 100% along with the bike. Attached ppt for your reference.

Hi, Since data is already captured in the revised delivery date,we want to see only active sheets.Thats the reason i want to delete it.

Th Thank you so much ! Its worked.Can you please help me with removing Show/hide macro as we want to see only active rows.Once again thanks for your help.

I think i explained you in reverse way.The revised delivery date shown flow from new data sheet which i completely replaced from B:F.Given below the output:

Hi, Yes.I gone through your file. Let me explain further with sample. For example :Given below my data which i received on last week (which is shown in Sheet name "Data" And output for the above should be as below In the next week,i will receive data from the customer which will be...

Hi Thanks for the workings. Unfortunately no.We will get customer data every week.Once we paste the data into "data sheet" the delivery date will not be same for the customer as it vary depends upon delivery schedule. We want to see the change happenned compared to previous import what date has...

I am reaching out to seek your expertise and assistance with a task we are currently facing in Excel. We have a database stored in an Excel sheet containing customer code, name, amount, and delivery date. In a separate tab, we are using a VLOOKUP formula to capture customer code, name, and...

Hi, Thanks for the reply.How to fix it?

Hi Friends, I am finding the below error in the macro (though i am not expert in macros).Can you please someone help in correcting it,which will be great help? Error: "range of object global failed" and appearing in the below row: For j = 1 To 7 Range("fraction").Cells(1, j).Value = 1...

Thank you so much.Let me know check on this.

Hi Everyone, I need a help on the below. I have task list for each employee in separate sheet for each country. They will update whether it is started, work-in-progress, pending or completed and they will have either specific tasks and some may have all tasks. In the summary sheet, we should...

Thank you so much for the reply. Let me check and got your solution.

Hi, Thanks for the reply. I want one chart for one customer with combined three colour chart. As per attached below:

Hi, Request your kind help to create stacked bar chart with help of sparlines with specified colours. Attached herewith excel file for further detail

Yes. Thank you so much ...

Hi, Thanks for the reply. I want to bring both plan and actual in one chart.Is anyway possible.Attached sample chart for your understanding.

HI, Both Plan & actual same together in one chart,where plan is available in "R'" column. Hope it helps.

Hi, I want to create Vertical waterfall chart with plan. Attached herewith excelsheet. Request kind help as always. Thanks

Got it. Thank you so much.

Perfect.Thank you so much. Can you please guide me how you did this,it will be a great help.

Hi, I need a help on the attached chart. I had created Budget vs actual chart with Revenue,Gross Margin & Netprofit. I want Budget comparison of each data with same length (i attached ideal chart - which should be look like) Instead three seperate charts,can i do in one chart Please advise