Charting
1378 Topics- How to create a Date-Time Temperature GraphHi 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! - Non35Views0likes1Comment
- why excel always put value of 1 when adding values in serieswhen 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.38Views0likes2Comments
- Request: Please Professionally Enhance My Gantt Chart TemplateHi 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!9Views0likes0Comments
- Help with data and visualsI 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, Thanks104Views0likes3Comments
- Excel charting problemsI am trying to plot excel data using a secondary axis. One axis of the data does not appear to chart correctly. I have tried to solve the issue using chat support with no success. I need to have someone look at the data file to see if they can fix the charting issue.48Views0likes1Comment
- Custom Sparkline FormulaI am in the process of moving to Excel from Google sheets. I am trying to build a project sheet and add a formula that will provide a "sparkline" for quick reference of the projected start and end dates, and then based on the status of the task (not started, in progress or complete) and today's date in relation to the start and end dates of the task, change color (Green, yellow, red, etc). Here is the formula I use in Google Sheets, but I cannot get it to work in Excel. =SPARKLINE(if(OR(today()<D5,today()>E5),{int(D5)-int($D$2),if(D5=E5,1,int(E5)-int(D5))},{int(D5)-int($D$2),today()-int(D5),1,int(E5)-today()}),{"charttype","bar";"color1","white";"color2",if(G5="Complete","grey",if(today()>E5,"red",if(AND(today()>D5,today()<E5,G5="Not Started Yet"),"darkred",if(AND(today()>D5,today()<E5),"orange",if(G5="In Progress","orange",)))));"max",int($E$2)-int($D$2)}) In this formula, Column D represents the start date and Column E represents the specific task end date. D2 and E2 represent the Project start and end date. Any Advice?Solved44Views0likes2Comments
- How to Make a Combination Chart with Line on Secondary AxisI used to be able to graph anything on Excel, but it seems like they have taken away all my control and put together wizards that don't work, if I don't have things formatted just the way Excel wants. I need some help understanding how to make this Wizard happy. When I try to choose Change Chart Type to Combo with Line on Secondary Axis, it is greyed out and will not let me choose it.Solved6.6KViews0likes10Comments
- How do I link a cell to another sheet in the same workbook, allowing me to view the sheet?I have a workbook containing a list of webpages in the first sheet. I want to be able to click on a cell and be directed to that sheet/tab, viewing the entire sheet, instead of clicking through a workbook with over 25 tabs. For example, in the attached screenshot, when clicking on the "Homepage content" cell in the first sheet/tab of workbook 1, it will take me to the "Homepage Content" sheet/tab in workbook 1, allowing me to view the entire sheet. I tried using the hyperlink formula, =HYPERLINK('Homepage Content'!A1,"Homepage Content"), but it doesn't work and have looked through several google search results as well. Any help would be appreciated, thanks!Solved278KViews0likes10Comments
- Filter function with a criteriaDear 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, AnupamSolved189Views0likes4Comments