Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!
New free Excel training courses from LinkedIn Learning on Support.Office.com
We have a whole new collection of training courses to help you get the most out of Excel 2016. Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other time-saving features. Please let us know what you think of these new courses. They’re free, along with the rest of the courses and videos in the Office Training Center. Best, Freya Office Newsroom
Making combo graph in Excel or PowerPoint for Mac
Hello. I have researched how to do this but I don't get the same command. I simply need to change the selection of which column of my data gets shown in the line, and which ones stay as columns in a combo graph. I really need this for PPT but the problem happens in Excel too: at the point right after I select "Chart type / Combo / Clustered Column - Line" there is SUPPOSED to be (according to all the videos and articles) a box that says "Choose the chart type and axis for your data series." This does not appear. This image below is what I actually see - after I select Combo chart then I do not see "how choose the chart type and axis for my data series" This is sample data that would underly the chart. I want the totals to be the line and the individual sales by week to be the columns. Here is the help article showing me what I should see: You see that box at the bottom of the screen "Choose the chart type and axis for your data series."? I can't find those commands. I don't get that option. I have spent 4 hours online research and 2.5 hours with Office 365 help and still can't solve this.
The problem with copied Excel charts and data
I often customise a chart, then copy both chart and data to another area ready for new data. I then amend the copied data, e.g. to show sales of a different business. If you do this too, you will encounter a problem… What you expect: The copied chart should be linked to the copied data – this is logical but not what actually happens. What you get: The copied chart is linked to the original data so doesn’t change when you amend the copied data. The selected data for the copied chart must be manually edited. This is a pain. ☹ And when you do that, you may well notice a second problem… If you have edited the original chart e.g., changed line colours, added customised markers and data labels, these are mostly lost when you amend the data source in the copied chart. ☹ ↪ The workaround You can copy the entire sheet, then cut and paste the graph on the copied sheet back to the original sheet, but this is inefficient. You may also have to edit the axis labels e.g., for years if these were linked to a row at the top of your (copied) worksheet. ✔ The proper solution Dear Excel development team at Microsoft… will you please fix this? PS I am using a laptop with Windows 10 and Excel 365
Comprehensive Excel Course
Excel for Beginners - 20 lessons: https://www.youtube.com/watch?v=EYli0htmje8&list=PLWZUhW4Wy9wOkcXPd1BobFtPVMgf_Rqao Excel for Advanced - 20 lessons: https://www.youtube.com/watch?v=AmYjiybz70g&list=PLWZUhW4Wy9wOno-celWEWyEzDaZdufkXE&index=2 This course has a clear, closed structure. Each lesson has an exercise file, which you can download from the link in the description. Watching the videos is fine, but if you want to learn how to do things mentioned in the videos, you should do the exercises while you watch. All the examples are based on real business cases. This course was not made by an Excel teacher, but an Excel professional, who has made a career working as an Analytical Manager in multinational Consulting, FMCG and Pharmaceutical corporations using the skills you will learn during this course. These two courses have all the knowledge needed for typical Excel tests, which are common at job interviews for corporations. The Advanced Excel course finishes with many authentic tests, like the ones conducted by corporations.
How to make a pie chart dynamically update by selecting a role from a slicer in Excel Pivot Table?
Hi everyone, I’ve created a table in Excel using Power Query, and the table name is All-Training. The table has the following columns: Process Training deliverables name Relevant to (workday role) Here’s a small data sample: Process Training deliverables name Relevant to (workday role) Compliance Training Data Privacy and Protection Employee Compliance Training Anti-Bribery and Corruption Employee Technical Training Excel Essentials Employee Technical Training Power BI Basics Employee Leadership Skills Coaching for Growth Manager Leadership Skills Leading High-Performing Teams Manager Compliance Training Workplace Ethics Manager Performance Management Goal Setting and Review Manager Technical Training Azure Fundamentals Engineer Technical Training Kubernetes Essentials Engineer Compliance Training Health and Safety Standards Engineer Performance Management Feedback Conversations Analyst Technical Training SQL for Data Analysts Analyst Reporting and Dashboards Power BI Advanced Reports Analyst Goal: I want to create an interactive Pivot Table and a Pie Chart that dynamically update when I select different roles from a slicer. Here’s what I expect: The slicer should allow selecting roles such as Employee, Manager, Engineer, or Analyst. When I select Employee, the Pie Chart should show two equal halves (50–50), because there are four training deliverables — two under Compliance Training and two under Technical Training. Similarly, when I select Manager, Engineer, or Analyst, the chart should update automatically to show the distribution of training deliverables across their respective Process values. I’ve already created a Pivot Table and inserted a slicer, but the pie chart doesn’t seem to update interactively when I change the slicer selection. Can someone guide me step-by-step on how to link the slicer, Pivot Table, and chart properly so the pie chart reflects the selected role’s data automatically? Thanks,
