Trick Excel into Creating Regular Charts from PivotTables - 3 Easy Techniques - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Vishnu
Hi Mynda, I have created three different workbooks with pivot tables and its source data.. when I try to merge it together using move or copy a link is getting created to the old sheet. Any suggestion how I can move the report and the source data which automatically updates the source data and no links are created..
Thanks in advance..
reply
Hi Mynda, I have created three different workbooks with pivot tables and its source data.. when I try to merge it together using move or copy a link is getting created to the old sheet. Any suggestion how I can move the report and the source data which automatically updates the source data and no links are created..
Thanks in advance..
reply
Mohamed
Thank you so much, your vedios are very helpful
so i've been thinking of investing more time in learing excel since its essential to data analytics
and before going any further i wanted to know if it will be worth it in the long run.
I would truly appreciate it if you could give me your opinion on this.
reply
Thank you so much, your vedios are very helpful
so i've been thinking of investing more time in learing excel since its essential to data analytics
and before going any further i wanted to know if it will be worth it in the long run.
I would truly appreciate it if you could give me your opinion on this.
reply
Paul
For me, the way to do this is to load the source data into the data model and then construct the table using a combination of cubemember and cuberankedmember formulas however its a bit more intricate to get the forumlas right and takes some more time, but its a bit more robust to changes in the data and formatting
reply
For me, the way to do this is to load the source data into the data model and then construct the table using a combination of cubemember and cuberankedmember formulas however its a bit more intricate to get the forumlas right and takes some more time, but its a bit more robust to changes in the data and formatting
reply
Sandro
Very helpfull! Thanks. But I'm also wondering if you have a solution for the Pivot -combo charts- that switch back to -Column- type. Because when I have added a slicer on this chart it changes it's chart type, which is really annoying. Hope you can help me with that :) Thanks in advance!
reply
Very helpfull! Thanks. But I'm also wondering if you have a solution for the Pivot -combo charts- that switch back to -Column- type. Because when I have added a slicer on this chart it changes it's chart type, which is really annoying. Hope you can help me with that :) Thanks in advance!
reply
In
Very good information. I-m wondering.. When you extend the ranges in the first examples to allow for growth is there a way to do that using offset or will that negatively impact the graph? I would be nervous just choosing a size when the data might extend past what I choose.
reply
Very good information. I-m wondering.. When you extend the ranges in the first examples to allow for growth is there a way to do that using offset or will that negatively impact the graph? I would be nervous just choosing a size when the data might extend past what I choose.
reply
SANJAYA
, make a video on conditional formatting.. I want to highlight a column if it is greter than the data present in other two column...
Example. If there r 3 column I want to highlight third column if it is greater than the data present in column 1 and column 2
reply
, make a video on conditional formatting.. I want to highlight a column if it is greter than the data present in other two column...
Example. If there r 3 column I want to highlight third column if it is greater than the data present in column 1 and column 2
reply
Arun
Hi,
I need to learn how to do the things explained below.
I would like to add an editable pivot table column which directly alters the source data whenever edited and vice versa.
Can you please help me learn how to do it ?
reply
Hi,
I need to learn how to do the things explained below.
I would like to add an editable pivot table column which directly alters the source data whenever edited and vice versa.
Can you please help me learn how to do it ?
reply
FreshWood
the way of creating the treemap and change its cell references to the area where there pivot table is located - very smart !! I was already upset that there is no default treemap diagram as a pivot chart available
reply
the way of creating the treemap and change its cell references to the area where there pivot table is located - very smart !! I was already upset that there is no default treemap diagram as a pivot chart available
reply
Ian
Many thanks, Mynda. Is it a general rule (not just in this example) that the chart source data addresses -must- include the sheet name, even if it is on the same sheet? I hadn't realised that!
reply
Many thanks, Mynda. Is it a general rule (not just in this example) that the chart source data addresses -must- include the sheet name, even if it is on the same sheet? I hadn't realised that!
reply
LastDance
This viedo is really powerful! Thank you Mynda! Its such a shame that the method 2 (GETPIVOTDATA) seems not applicable to PowerPivot and only works with PivotTable.
reply
This viedo is really powerful! Thank you Mynda! Its such a shame that the method 2 (GETPIVOTDATA) seems not applicable to PowerPivot and only works with PivotTable.
reply
Add a review, comment
Other channel videos
