Search found 16 matches

by CecileBF
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!
by CecileBF
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 !
by CecileBF
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).
by CecileBF
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?
by CecileBF
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...
by CecileBF
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 ?
by CecileBF
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...
by CecileBF
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
by CecileBF
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
by CecileBF
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...
by CecileBF
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?
by CecileBF
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...
by CecileBF
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)?
by CecileBF
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...
by CecileBF
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...

Go to advanced search