Hi Folks
I've found online a way to find and replace words in a title for all charts on a sheet but I want to be able to specify specific charts.
In the example below, I only want to update Chart 11.
As I turned off the For/Next statement, I set ch as ChartObject
It crashes on the first line of...
Hi,
I'm sure this question must have been asked before, I have searched and can't find the exact answer; I know how to link a chart title to a given cell so it becomes dynamic, but not to a pivot chart timeline.
I have some pivot charts with slicers & timelines that work absolutely fine, but I...
I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...
I am graphing weekly data in a Pivot Chart over a range of time. The time values aren't stored as dates but names like "14wk01" or "14wk37". Right now the time filter selects multiple items to display so I can see data over time. My ultimate goal would be to include the beginning and end time...
I have data in cell A1 that I am using as the chart title. I also want to add some text.
e.g.
=a1&"test"
Is this possible? I keep getting errors back??
Thanks for any help - appreciated.
Hi all,
creating a dynamic title for a chart is rather straightforward. Select title box, enter = in formula box, refer to any cell and hit enter.
Today I tried this in a Pivot Chart. Since Excel 2013 you can have pivot charts without creating an underlying pivot table (which is new to my...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.