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
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, Anupam
