ANSWERS: 2
  • While you are working your way through the Chart Wizard type the names you want as the chart title and at the bottom (x axis) and side (z axis). Once the chart is in place you can edit existing titles by clicking on them or put titles in where none exist by right clicking in the white border area and selecting 'Chart Options', which will bring up the part of the wizard shown in the screen shot - click on it to enlarge.
  • It's not well documented (in fact, I've never seen it in any Microsoft documentation) but you can include "live" titles and other chart elements. Add a title using either the Chart Wizard or the Charts toolbar (which allows you to add discrete elements to the completed or in-process chart after you're done with the wizard, or instead of it). Okay, now that you have a typical "static" title (or other element) click on that element and then click on the formula bar to enter a fully qualified reference to the element you want to include. I will explain what that means, in case you don't understand "fully qualified". Cell A1 is plain text. Cell A2 is =now() Cell A4 is =A1 & CHAR(10) & TEXT( A2, "hh:mm:ss") As you can see, the 'Title formula' in the chart is =Sheet1!$A$4 This is the 'full qualification'. Even though the formula is on a chart on Sheet1, you still need to include the reference to "Sheet1" as part of the formula to call out the value I want to appear in my title. The beauty of this is that if values on the chart change (such as time, in this example), then the chart title also changes with zero additional user input.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy