Why would you want to use a horizontal line It could be a break-even line for revenue or a threshold making it easy to spot specific dates/months/years containing interesting data points. Two limitations of the above line chart are: Since the numbers being used to measure each variable are so far apart, it is difficult to see the changes and fluctuations to the numbers which carry a smaller value (Daily Temp). Excel allows you to combine two types of charts, in this case, I am going to combine the column and the x y scatter chart. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. The following shows the result of creating a line chart when a scatter graph should have been plotted instead. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block The following graphs are examples of scatter. This will award the user a ClippyPoint and change the post's flair to solved. including trend lines (least squares), confidence limits, polynomials, splines, loess curves, and border plots. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |