Search found 16 matches
- Mon Jun 16, 2025 2:27 am
- Forum: Data Manipulation
- Topic: stacked bar plus line graph
- Replies: 26
- Views: 99340
Re: stacked bar plus line graph
This works well, thank you!
- Fri May 30, 2025 5:11 am
- Forum: Data Manipulation
- Topic: Importing complex Excel files
- Replies: 5
- Views: 43561
Re: Importing complex Excel files
Dear Steve,
I forgot to say it: thanks A LOT for the response, I've done a similar program thanks to your advice and my problem is solved, it works perfectly well !
I forgot to say it: thanks A LOT for the response, I've done a similar program thanks to your advice and my problem is solved, it works perfectly well !
- Fri May 30, 2025 2:31 am
- Forum: Data Manipulation
- Topic: stacked bar plus line graph
- Replies: 26
- Views: 99340
Re: stacked bar plus line graph
exactly these types of graphs: stackedbars (representing the contibutions) + symbol "circle" instead of a line (for the total).
- Wed May 28, 2025 10:32 am
- Forum: Data Manipulation
- Topic: stacked bar plus line graph
- Replies: 26
- Views: 99340
Re: stacked bar plus line graph
and how do you code symbol (FILLEDCIRCLE) instead of a line?
- Mon May 06, 2024 9:26 am
- Forum: Programming
- Topic: Delete Empty Rows from a Table
- Replies: 4
- Views: 13129
Re: Delete Empty Rows from a Table
Hi! Jun said he found a solution but did not mention which one. So because it can be useful for other users, I post my own solution here. The way I deal with a similar issue is by running the loop in reverse: for !nbrow=@rows({%nametable}) to 2 step -1 if {%nametable}(!nbrow,1)="" 'here is...
- Mon Apr 08, 2024 1:50 am
- Forum: Data Manipulation
- Topic: Importing complex Excel files
- Replies: 5
- Views: 43561
Re: Importing complex Excel files
Thanks for your response. The issue is the fact there are a lot more variables than what I showed (so a lot of columns) so I try to find a way to do it automatically... Even with several steps. Do you have any suggestion ?
- Fri Apr 05, 2024 6:33 am
- Forum: Data Manipulation
- Topic: Importing complex Excel files
- Replies: 5
- Views: 43561
Importing complex Excel files
Hi, I use Eviews 13 Enterprise. I am trying to import Excel files to extract values, in order to reconstruct at the end times series. Basically, the structure looks like it: Gross Domestic| |Household | |Gross Fixed Product ||Consumption ||Investment Prev 1 | Prev 2 | Prev 1 | Prev 2 | Prev 1 | Prev...
- Wed Feb 14, 2024 3:34 am
- Forum: Data Manipulation
- Topic: Automatic update of a workfile based on Excel files
- Replies: 4
- Views: 42311
Re: Automatic update of a workfile based on Excel files
Thank you! I tried and it works for me that way as well too.
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040
But I create a workfile before this step and the problem re-appears now:
wfcreate(wf=TRANSITION\dbpmi, page=m) m 1992 2040
- Wed Feb 07, 2024 8:14 am
- Forum: Data Manipulation
- Topic: Automatic update of a workfile based on Excel files
- Replies: 4
- Views: 42311
Re: Automatic update of a workfile based on Excel files
The file is based on data from IHS Markit (for information).
Regards,
Cecile
Regards,
Cecile
- Fri Feb 02, 2024 2:57 am
- Forum: Data Manipulation
- Topic: Automatic update of a workfile based on Excel files
- Replies: 4
- Views: 42311
Automatic update of a workfile based on Excel files
Hi, I created a program to import some series from an Excel file. Basically, the import code is built that way: import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector&quo...
- Thu Jan 04, 2024 2:33 am
- Forum: Programming
- Topic: Occasional problems with special pasting in powerpoint
- Replies: 2
- Views: 31140
Re: Occasional problems with special pasting in powerpoint
Thank you! So I guess since the cause remains unknown, there is no clue on ways to avoid them? Or are there ways to prevent them?
Or should I contact Microsoft directly?
Or should I contact Microsoft directly?
- Fri Dec 29, 2023 9:03 am
- Forum: Programming
- Topic: Occasional problems with special pasting in powerpoint
- Replies: 2
- Views: 31140
Occasional problems with special pasting in powerpoint
Hi, I used the special pasting as Object Linking and Embedding (OLE) for integrating graphs in a powerpoint presentation which I and my colleagues update regularly. It works quite well, however sometimes, especially as I am manipulating the original workfile, the graphs can disappear. It seems to be...
- Tue Oct 17, 2023 2:39 am
- Forum: Data Manipulation
- Topic: Changing date format in graphs
- Replies: 5
- Views: 78664
Re: Changing date format in graphs
Thank you, it is very helpful! By the way, is there a way to code this option (for interoperability of programs with my colleagues)?
- Wed Oct 11, 2023 8:43 am
- Forum: Data Manipulation
- Topic: Changing date format in graphs
- Replies: 5
- Views: 78664
Re: Changing date format in graphs
Can you help me do this? Here are the typical lines I write before to determine the most recent date (which I then report in the graph's title) of at least one of the series on the graph: %seriesdugraph="eme_detteprivee adv_detteprivee dettetotale" group seriesgraph {%seriesdugraph} series...
- Tue Oct 10, 2023 12:40 am
- Forum: Data Manipulation
- Topic: Changing date format in graphs
- Replies: 5
- Views: 78664
Changing date format in graphs
Hi, I use floating text to indicate my last point on subtitles of graph. Basically, here are typical lines I would write: {%g}.addtext(t,font(calibri,14,b)) "Dette privée (% de PIB mondial)" {%g}.addtext(1.80, -0.32,font(calibri,12), keep) Source: BRI, dernier point: {%last} %last referrin...
