Ask Your Question
0

Insert a cell value into a graph?

asked 2019-07-22 04:02:48 +0200

doorrag gravatar image

I have a spreadsheet with DATA and a Chart. I want to show on the chart the value in a cell of the DATA sheet which will vary in value and position from time to time.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-22 09:53:11 +0200

Opaque gravatar image

updated 2019-07-22 09:54:17 +0200

Hello,

please see the answer to a similiar question. But the limitation is: If you ever want to show up the value of another cell than initially defined as the linked cell within the text box control's properties, you need to modify the Linked Cell within the control box.

I'm not aware of any other solution.

edit flag offensive delete link more

Comments

Thanks. It seems very complicated. I'm sure it was a lot more straightforward in Excel! Anyway, I'll give it a go.

doorrag gravatar imagedoorrag ( 2019-07-22 10:28:38 +0200 )edit

In fact, this solution can be considered a "workaround" only, since there is no designed solution "Show cell values" for a chart. If you have a requirement for this, and you want developers to implement as a real functionality of the chart wizard, you are welcome to file an enhancement request here.

Opaque gravatar imageOpaque ( 2019-07-22 10:50:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-22 04:02:48 +0200

Seen: 17 times

Last updated: Jul 22