How to sum chain values from N-number cells?
Hello, I have data of people by age, but 100 different values on a line chart would look... bad. Hence the need to group ages in sets of 5 or 10 on a separe line in chain, but what is the function to do this? It certainly isn't the humble SUM function, since it moves the range by one, producing "1 the problem". Sure, I could do the SUM chain and delete four cells between keepers, yielding "2 the problem", but that's just awful. Or I could do "WHAT I SEEK" manually, if I had an enernity... Thanks in advance, and have a wonderful day!
multi Vehicle maintenance log record
i need to make a vehicle maintenance log that will have 7 different vehicles, track all the oil changes, inspections, registrations that will notify us when something is expiring, and be able to attach receipts and documents to it. what is the best way to do this?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,
How to create a Date-Time Temperature Graph
Hi there, I was wondering if Excel is able to create a similar Date Time vs Temperature graph as shown, the green coded one? (the data was extracted from an app) I want to be able to show the Date AND Time on my Excel chart I have the raw number data but is unable to convert it into a graph similar to the one shown above, for reference the format of my raw data looks like this (below), but my raw data have three thousands results. Thank you in advance to anyone who can help me! - Non
why excel always put value of 1 when adding values in series
when I create a chart, I start adding the series in respective manner, I found that when I add new series, the series value filed always by default shows this value in the field = {1}, which every time I have to delete it before I choose my values from the worksheet. How to avoid this issue as it is struggling and slowing my work. I believe it can be avoided.
Request: Please Professionally Enhance My Gantt Chart Template
Hi everyone, I’ve created a basic Excel Gantt chart template for suppliers to use when discussing project timelines with landowners. The chart lists tasks on the left and shows the duration of works by month from October 2025 to April 2026. My Excel skills are quite basic, so I’d really appreciate if someone could directly improve the template for me. Specifically, I’m looking for: A more professional and visually appealing layout Clearer formatting for tasks and timelines Automatic highlighting of active months for each task Conditional formatting to make the chart easier to read Any other practical enhancements that would make it more effective for supplier discussionshttps://docs.google.com/spreadsheets/d/1SdPU8HEsHDjOHljwYsPnRmRHHNrJ5Whq/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=true This is only a template and contains no sensitive data. I’ve attached the file—please feel free to make changes directly to the chart. Thank you very much for your help!
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tracker: It would look for the charts and figure out the timeline and add them to a row with the timeframe: example is Booy 15-0ct-25 to 23-oct-25 the char would go to the next one and add his information, I hope someone can help me. I just need it to populate the month tracker, Thanks
