Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have following Table,
G1 | G2 | Gtotal | Month |
---|---|---|---|
2 | 5 | 7 | Apr |
3 | 2 | 5 | May |
4 | 1 | 5 | Jun |
5 | 4 | 9 | Jul |
I want to make bold only Gtotal Field and its value.Could anyone provide me the syntax to bold this field to put in text format of the expression.
Thanks in advance
Then try like
if(Project = 'Gtotal', '<B>')
By click plus sign in Text format option of the expression.
For this use option Custom Format Cell and right click on the chart column for that and from option Custom Format Cell you change column as bold and check this option is enable or not from Properties >> User preference >> Design >> and enable Always Show Design Menu Items.
Hi,
Go to chart properties --> expression tab --> click on "+" sign --> go to Text Format --> '<B>'
And there is another option by click on plus sign in expression and write '<B>' or '<I>' B for Bold and I for Italic
And even you use
For Italic <I>
For Bold <B>
For Underline <U>
Project | Apr | May | Jun |
---|---|---|---|
G1 | 2 | 9 | 8 |
G2 | 3 | 6 | 1 |
Gtotal | 5 | 15 | 9 |
A1 | 8 | 5 | 4 |
A2 | 6 | 4 | 2 |
Sorry guys I want to make change in the table which I shared,The table is like above where issue is to bold Gtotal which sum the value of G1 and G2 in excel ,so this row must be bold.
Use '<B>'
or custom Format Cells.
For Custom Format Cell do the following Setting:
1. Ctrl+Shift+U or Simply Go to Settings > User Preferences and then move to Design Tab > Check the Option "Always Show design Menu Items" > The Chart on which you have to make the Colored rows > Right Click on it > There you see the Option Custom Format Cells > From there you can change colors, format, etc.
Regards
Aviral Nag
It's also worth saying bhawna, if you are just looking to bold the expression, either of the two above will work for you.
However if the bold needs to be applied based on a criteria, the text format from the expression will need to be used
hope that helps
Joe
Then try like
if(Project = 'Gtotal', '<B>')
By click plus sign in Text format option of the expression.