Forum

Notifications
Clear all

Add dynamic cell data to chart

4 Posts
2 Users
0 Reactions
100 Views
(@rwmill9716)
Posts: 3
Active Member
Topic starter
 

How do I add the information in a cell to a chart so as the information in that cell changes, the chart information changes too?  I can do this through the Chart's Title assignment, which is how I included the information in the bottom of the attached chart, but I would like to include individual inserts instead of the single line. The second attachment shows the Title line I've used.190630-Running-Goals.jpg190630-Dynamic-Chart-1.jpg

 
Posted : 01/07/2019 10:44 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Ric

One way is to copy-paste a linked picture of the range and then move it onto your chart.

Hope this helps.

Sunny

 
Posted : 01/07/2019 8:57 pm
(@rwmill9716)
Posts: 3
Active Member
Topic starter
 

Thanks Sunny,

I want to be able to change the information in the Excel cell and have that change be also made automatically to the chart. I can do that a single time through the chart title assignment, but I would like to do it more than once.  That is, right now I have to crowd all the information on a single line.

 
Posted : 02/07/2019 11:41 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Ric

Maybe I am not too clear about what you wanted.

It would be better if you can attach what is your expected result, preferably an Excel file with some test data.

It will help us understand your needs better.

 
Posted : 02/07/2019 7:02 pm
Share: