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. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
The typical dynamic range chart advice is to use a. But what if you want to create a chart where the data range gets bigger or smaller based on criteria That is where you will want to create a chart with a dynamic range. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. A standard chart in Excel uses a defined set of cells for the category axis and the data values. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. Right click on the left axis and choose Format Axis. Heres where the logarithmic scale comes in very handy. OPs can (and should) reply to any solutions with: Solution Verified If we create a cluster column chart from this data, well get something like this: Its easy to visualize Clevelands and Pittsburghs data, but the others are too low on the scale to detect the variances.