Basically I need one slicer in the whole dashboard but the pivot/graph selection is based on 4 week for few graphs and 1 week for some of the graphs.. Is that possible?
Thank you
Regards
Hi,
Request your help/suggestion.
I wanted to know if there is a possibility that the excel slicer linked to graph few graph showing(connected) multiple selection and the same slicer can change the graph with one selection. The same slicer being linked to multiple graphs but the graph...
Hi,
Is there any way of adding pivot to the data and linking to the graph as attached.
I have attached a sample copy of the file with the desired output. I am looking a way out for automating the desired output with the help of pivot and graphs.
Any help will be appreciated.
Thanks
Hi All,
I am working on to send auto birthday emails from excel through outlook.
I have a list of entries where the DOB and email id's are mentioned. I need the macro which auto send the emails as an when its the current date without any reminders or pop up emails. Its just that if in case I...
Hi Team,
I am looking out for the solution to ignore 0 values in the graph when the range with formula output is zero(in bar graph).
Please find attach the screenshot. I dont want to chch and LBC in my chart as there are no values for it. Looking out for auto option.
And my range is
Any...
Hi Team,
I want to display no bar(data) in my graph if the data range is blank or 0 zero value. In the below case i only want to show Northgate bar excluding the rest.
Manually it is possible by selecting North gate range only. What if i want to keep the whole range in the chart and exclude...
Yes you are right..they are not linked to pivots. But the numbers are picked up from pivots. I had created 4 different tables for the same(In the filter option country should be AUS and category should be Payroll management and the same for NZ as well. As of now I am doing it manually. so I am...
This seems to work fine.
But actually, in my dashboard there are 4 different graphs for which the numbers comes from the above pivot, eg. AUS -Payroll management and AUS - Talent & services and same as for NZ. so can u help me achieving that results. I need to link that tables to graph may be i...
Hi
Thanks for your reply.
It seems to be working fine.Can you please let me know what you had done to get it.
One more thing, I can see is the select data range for the graph seems to be greyed out.
Regards
Jaya
Thank you for your reply.
It seems you have linked the formulas with the pivot table as when I change the country to New Zealand. It is not coming up with proper output.
It would be better to update or link formulas based on the Raw data sheet according to the pivot table filter criteria...
Hi Team,
Request you to help with the formula calculation in the attached sample file.
Also, is there a way to use the shared file (formula table) in my other excel dashboard workbook.
Regards
Jaya
Hi Team,
Please help me with a solution to automate the graph with the pivot data without using table. My graph needs to be refreshed when the pivot data changes.
VBA macro solution is also fine. Please find attached the sample file for reference.
Thank you in advance.
Regards
Jaya
Hi
If you have recently upgraded to Excel 2016 and don’t have a Power Pivot tab available to you, there are a couple things you can do. You might want to go to the Developer tab and click on the COM Add-ins icon, which will display a list of the Add-ins available. If Power Pivot is available...
Hi Naresh,
Welcome to the Forum!!
Firstly the result what you had requested is not possible through conditional formatting.
You can apply conditional formatting using values and format it to expected color.
But you can put/show values based on colors.
For eg: if cell have green color then...
Hi Dokat,
Please try the below code:
Sub RefreshAllPivotTables()
Dim PT As PivotTable
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
For Each PT In WS.PivotTables
PT.RefreshTable
Next PT
Next WS
End Sub
Note: It will refresh all the pivots...
Hi,
Can you please share the excel file so that it is easy to work.
Also show the expected results in the particular field so that it is easy to help you.
Thanks
Jaya