10/31/2023 0 Comments Excel 2016 chart axis labelsWe will add two series, whose data labels will replace the built-in axis labels. The horizontal axis dummy series (gray line and circle markers) uses the column of numbers (E2:E8) as X values and the column of zeros (F2:F8) as Y values. The vertical axis dummy series (yellow line and circle markers) uses the same column of numbers (F2:F8) as X values and the column of numbers (E2:E8) as Y values. Setting the axis scales at ☓5 also locks the axis labels at half-multiples of 10 (at the 5’s: -35, -25, etc.). The margin around the plotted points is wider than desired, but any attempt to place the axis labels on multiples of 10 result in something like the chart above (±40) with too wide a margin, or the chart below (☓0), with no margin. At this scale, the default axis limits are ±40. Here is the chart, squared-up so the gridlines outline approximately square regions. I guess it’s a question mark symbolizing the confusion expressed by the original questioner. Here is the XY Scatter chart of the First (blue) and Second (orange) data sets. The First and Second blocks are used for the chart’s main series the Axis block is used for both dummy series and the Err Bar block is used if you don’t want the error bars to obscure the default axis lines. Positioning your own custom axis labels and gridlines is not too difficult to do, by dispensing with the default labels and gridlines, and using dummy series along the X and Y axes, with data labels and error bars on these series. However, it’s not part of Excel’s charting engine, nor of many other charting packages. It was a built-in feature of the first charting software I ever used, but then, I wrote that software myself in the mid-1980s. It seems like this should be easy in any charting software. Essentially, the user wanted to scale the axes of his plot to ☓5, but have axis labels every 10 units centered on zero, not starting at -35. I came across a post on the Super User forum whose author wanted to Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |