T O P I C R E V I E W |
Ina123 |
Posted - 07/20/2020 : 05:33:05 AM Hi, I have a graph with columns and error bars. In the worksheet the data are marked as "y" (45%) and "yEr" (+-3%). Is it possilbe to lable the columns with the yData and the yError data? For example the lable of the column would be 45%+-3%? Thank you. |
3 L A T E S T R E P L I E S (Newest First) |
Ina123 |
Posted - 07/21/2020 : 02:19:07 AM quote: Originally posted by YimingChen
In Plot Details dialog, go to Label tab, change label Form to Custom, set Format String as $(wcol(n)[i], *2) +- $(wcol(n+1)[i], *2). See if it works.
Yiming
Wow, that's great, thanks a lot! I never would have been able to do it like this |
YimingChen |
Posted - 07/20/2020 : 10:21:05 AM You can also make another label column (see fig), right click on the column and select Format Cells..., check Rich Text. This is to allow plus minus sign to show in cells.
James |
YimingChen |
Posted - 07/20/2020 : 08:53:39 AM In Plot Details dialog, go to Label tab, change label Form to Custom, set Format String as $(wcol(n)[i], *2) +- $(wcol(n+1)[i], *2). See if it works.
Yiming |
|
|