Skip to main content
Best Answer

trouble charting data in Excel

  • May 8, 2018
  • 2 replies
  • 22 views
1
Forum|alt.badge.img+1

Hi, I'm using an Excel template file to chart some data that I write to Excel - I've attached some example data and workspace. When I populate the 'data' sheet, I want the chart to update with the latest data. I've tried to achieve this by setting the chart data source to '=data!$A:$D', so it should look at all rows in those columns), but Excel seems to default to =data!$A$1:$D$1. So when I run the workspace the chart is not updated to reflect the data in the 'data' worksheet.

Does anyone have any other methods for achieving this? I want the chart data source to use dynamic references rather than fixed, so that whatever amount of data is input to the 'data' worksheet, it is plotted on the chart.

Thanks for your hep

Mary

Best answer by markatsafe

I think we have figured out how to create the Excel template so that the chart updates automatically when you load different datasets. I've added some notes to the original article.

1 Attachments
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

diwanicka
Forum|alt.badge.img+4
  • diwanicka
  • May 8, 2018

Hi @1spatialmary you may want to try creating a named data range in your template. This tutorial should help you with what you want to do. https://knowledge.safe.com/articles/34364/using-a-template-file-when-writing-excel-data.html

 

M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • May 9, 2018

I think we have figured out how to create the Excel template so that the chart updates automatically when you load different datasets. I've added some notes to the original article.

Community Stats

32,182
Posts
122,179
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.