I am having issues with how the title appears on top of the chart. I want the budget to be at center with respect to plot area, not with respect to whole chart area(which it currently is set to).
i set title alignment by doing the below:
I don't think you can control this using the chart settings.
Maybe use text box as wide as the plot area with centered text instead?
(Background can be made transparent)
did you mean put text box on top of chart, make background transp for table box...? for that disable title settings at all for chart?
Right, disable the title in the chart and use a text box instead.
Won't work very well if you need to minimize / maximize / move your line chart. But may work within a dashboard.
I will try and see if it works.
or is there script like chr(10) which instead allows space break instead of line break..?
Could you elaborate further on that? How you want to use a character code to center over the plot area?
If you hit Ctrl+Shift while that chart is selected, red outline boxes will appear around individual 'parts' of your chart. You should be able to move around the position of the title.
What I meant was just as chr(10) creates another line if we want a row of text to be in the next row, I was wondering if there was similar code that creates spaces. may be &' ' will work
Yes, you can try to add a number of spaces like
='Title' & Repeat(chr(32),10)
but this might also just be a dirty work around. Available plot area might change depending e.g. on length of your legend values. Nevertheless, I would give it a try.
May be using the Ctrl + Shift Option?
You can use it , for two lines,
'1st Line' &chr(10)& '2nd Line'
Go with -> Control+Shift
and Position it as you require.
Retrieving data ...