(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Charting Data (Read 1240 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Charting Data
Aug 2nd, 2017 at 1:32pm
Print Post Print Post  
In my operation, we often chart data to look at performance over time.  We often download data from Sesame into an Excel spreadsheet, manipulate the data and then create a chart.  Often using the pivot table function in Excel.

Is there any way to make this automatic?  Does Sesame have the ability to combine data and then to create a chart?
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Charting Data
Reply #1 - Aug 3rd, 2017 at 1:31am
Print Post Print Post  
The answer for this is most likely in Excel.   Sesame can easily create an export file of data and open an Excel spreadsheet, linked to the mergedata.txt file, with an auto run macro to generate your chart.   You may need to use some VBA code to fine tune it.

There are many good articles in Inside Sesame on Word Merge.   Just use an Excel sheet vs. a Word document.   See June 2010 issue article by Carl Underwood.   I am currently using that now for a new project.

=============

To see examples of Excel coding,  just Google for:
excel auto macro to make chart from import

Here is a sample of one example:
VBA: A Simple Tool to Open a CSV File and Create Chart with Data Specified by User

https://peltiertech.com/simple-vba-open-csv-file-chart-user-specified-data/

================
To see examples of more Excel coding,  just Google for:
excel auto macro to make pivot table chart from import

More specific to PivotTables:
Automatically refreshing Pivot Tables in Excel Refreshable Reports

http://www.eonesolutions.com/blog-post/tech-tues-automatically-refreshing-pivot-...
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge