Excel pivot chart connect line2/13/2023 ![]() Things like that drive me to hiding an intermediate Query. For example, I have the raw data in a visible and I create a Query that I know I am going to use to create another table or to merge with another table. When would you hide a Query? I do so when I create an intermediate table that I don’t need to see. When we create a Query, we can click Close and Load to… and choose from the following list:Ĭhoosing Only Create Connection will save the Query but it will be hidden: there will be no entry in any worksheet. ![]() ![]() I have created blog entries on both of those issues, by the way. I also faced problems such as the percentages disappearing from a Query and the I faced when updating and refreshing a Query. There is no Excel file or video here but if you really need to learn how to do these things, this is one of the best explanations you will find.Īs I have been working on some Power Query models, I have been thinking about aspects of them and Pivot Tables that I have not considered before. This post is a comprehensive introduction to using Power Query Connections in Excel, especially using them to create Pivot Tables and Charts. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |