Width and align of a title of the chart

kubazabran

New Member
Joined
Feb 22, 2022
Messages
9
Office Version
  1. 365
Platform
  1. MacOS
  2. Web
Hi, is there a way how to set 100% width of a title text field in a chart and have text horizontally centered? I'd like to dynamically change title based on the value in different sheet and it seems the change of title always broke the layout. I

Thanks!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
4,051
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Haven't tried it, but remove the title from the chart. Add a textbox. Set the value of the textbox to a cell (using =D5 in the formula bar) . Then set the textbox to full width and centred text.

I think that will work fine.
 
Solution

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
5,266
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
The "official" chart title can only be 80% or less of the chart's width. I don't know why; it makes me crazy also.

@sijpie suggests a testbox, which you can make as wide as the chart.

To link a chart text element (chart title, axis title, data label) or shape to a cell, select the chart element or shape, click in the formula bar, type =, and select the cell with the text you want displayed. You will get a link like =Sheet1!$A$1; note the address includes the sheet name. When you change the text in that cell, the formula displays the text in the chart element or shape.
 

Forum statistics

Threads
1,181,058
Messages
5,927,882
Members
436,575
Latest member
Tiger750

We've detected that you are using an adblocker.

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.
Go back
Top