You can also create a combination chart by using more than one chart type in your chart. The data points of the data series that are plotted in the chart. The horizontal (category) and vertical (value) axis along which the data is plotted in the chart. For example, you might want to change the way that axes are displayed, add a chart title, move or hide the legend, or display additional chart elements.Example of a combination chart that uses a column and line chart type. To modify a chart, you can do one or more of the following: Instead of manually adding or changing chart elements or formatting the chart, you can quickly apply a predefined chart layout and chart style to your chart.
However, we can use a formula to make the title dynamic instead. I have a macro that changes values that are the data for a chart. Basically I'm running a dashboard, and I have a bunch of named ranges that are populated with return values from some UDFs. Left = Int Temp Left Next co End Sub Just spent half a day on this myself. Select End If End If On Error Go To 0 I had the same issue as the poster. This helps the data stay in sync, so you won't have incorrect or out-of-date information in your chart. An Excel spreadsheet containing the chart's source data will appear.After you have finished editing, be sure to save the chart in Excel.