Hi all,

I have plotted a connected line graph for four series ("Too cheap", "Cheap", "Expensive", "Too Expensive") by category (Treatment Groups - 4)


[ATTACH=CONFIG]temp_29893_1674032131339_234[/ATTACH]

I need to create a bar chart plotting the four intercepts per graph also by category.
So Ideally, have 1 bar chart containing a bar per intercept over the category (4 intercepts per category = 16 bars).

My line of thought is to create variables for the intercepts which are as follows, and then plot these? But I am very lost with the commands. Or maybe someone has a better suggestion?

PMC Intercept of Too cheap & Exp
PME Intercept of Cheap & Too Exp
IPP Intercept of Cheap & Exp
OPP Intercept of Too cheap & Too Exp

Would be grateful for any help or suggestions.

Thanks,
Carmen

Below is some of my data

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte Treatment_Group double Too_Cheap int Cheap double(Exp Too_Exp) float(demand_Too_Cheap demand_Cheap demand_Exp demand_Too_Exp)
2    0  1   5  9  .9972376 .9972376 .002762431 .002762431
1    5  8  12 20         . .9917127 .005524862 .005524862
2    5 12  23 22         .        . .019337017 .008287293
3   11 12  21 23  .7762431        . .011049724 .011049724
2   15 17  23 25         . .9281768          . .016574586
3   13 16  24 25  .7679558        .  .02209945          .
3    5 10  15 29         .        . .008287293 .019337017
3    1  5  25 30         . .9944751          .  .04143646
2   10 20  25 30         .        .          .          .
2    3 10  25 30   .980663        .          .          .
3   20 30  35 30         .        .          .          .
1    5 10  25 30         .        .          .          .
3    5 20  40 30         .        .          .          .
2   10 20  25 30         .        .          .          .
3   10 15  25 30         .        .          .          .
2   10 16  30 31         . .9337016          .   .0441989
3   12 17  30 35         .        .          .  .05801105
1    5 12  25 35         . .9640884          .          .
2    5 25  35 35         .        .          .          .
3   25 20  50 35         .        .          .          .
1   15 20  50 35         .        .          .          .
1   35 25  40 36 .22099447        .          .  .06077348
3   15 20  32 39         .        .  .07458564  .06906077
1   19  9  29 39         . .9889503  .04696133          .
1   20 29  36 39         .        .          .          .
1   10 20  35 40         .        .          .  .11325967
1   20 30  35 40         .        .          .          .
4    9 10  25 40         .        .   .0441989          .
3   10 30  60 40         .        .          .          .
2   15 20  35 40         .        .          .          .
3    5 10  35 40         .        .          .          .
1   10 18  30 40         .        .  .06906077          .
1   20 25  35 40         .        .          .          .
2   10 25  39 40         .        .  .13535912          .
3    5 15  30 40  .9751381        .          .          .
3   15 25  35 40         .        .          .          .
4    1 15  30 40         .        .          .          .
2    1 10  30 40         . .9861878          .          .
1   10 20  35 40         .        .          .          .
2   10 30  35 40         .        .          .          .
3   15 20  30 40         .        .          .          .
4   10 20  35 45         .        .          .  .13259669
2   20 25  36 45         .        .  .12707183          .
1   12 25  50 45  .7734807        .          .          .
2   25 30  50 45         .        .          .          .
1   20 25  40 45         .        .          .          .
2   20 30  50 45         .        .          .          .
4    5 10  35 45         .        .          .          .
3   29 19  39 49         . .9171271          .  .13535912
2   15 45  35 50         .        .          .   .2237569
3   20 35  60 50         .        .          .          .
2    9 20  35 50  .9226519        .          .          .
4   20 30  35 50         .        .  .12154696          .
1   15 30  45 50         .        .          .          .
1    5 20  49 50         .        .  .22099447          .
3   25 30  70 50         .        .          .          .
2   15 25  40 50  .7651933        .          .          .
1   10 20  40 50         .        .          .          .
3   20 30  40 50         .        .          .          .
4   10 25  35 50         .        .          .          .
4   10 20  40 50         .        .          .          .
1 9.99 25  40 50  .9171271        .          .          .
3   10 30  60 50         .        .          .          .
1    3 20  75 50         .        .          .          .
3   40 40  60 50         .        .          .          .
1   15 20  40 50         .        .          .          .
3   10 25  50 50         .        .          .          .
4   20 30  45 50         .        .   .2154696          .
3   15 25  45 50         .        .          .          .
3   10 20  30 50         .        .          .          .
3   10 18  40 50         . .9226519          .          .
4   10 20  40 50         .        .          .          .
1   10 30 100 50         .        .          .          .
4   20 30  43 50         .        .  .19060774          .
4   20 30  49 50         .        .          .          .
3   10 10  40 50         .        .          .          .
4    5 12  35 50         .        .          .          .
1    5 15  22 50         .        . .013812155          .
4   25 40  75 50         .        .          .          .
4   20 60  80 50         .        .          .          .
2   15 25  40 50         .        .          .          .
3    0 15  31 51         . .9530387   .0718232  .22928177
2   30 39  40 51         .        .   .1878453          .
1   35 40  50 55         .        .          .  .24309392
1   15 22  38 55         . .8314917  .12983425          .
1   15 25  70 55         .        .          .          .
3   25 25  65 55         .        .          .          .
3   18 25  45 55  .6629834        .          .          .
1   10 20  40 60         .        .          .   .3066298
2   15 29  50 60         . .7430939          .          .
1   10 20  50 60         .        .          .          .
2   20 35  50 60         .        .          .          .
2    5 15  50 60         .        .          .          .
3   20 45 100 60         .        .          .          .
1   18 40  55 60         .        .          .          .
3   30 40  50 60         .        .          .          .
3   20 35  55 60         .        .          .          .
1   10 40  50 60         .        .          .          .
3   25 30  50 60         .        .          .          .
1   20 30  75 60         .        .          .          .
end
label values Treatment_Group Treatment_labels
label def Treatment_labels 1 "1. Control", modify
label def Treatment_labels 2 "2. SOC", modify
label def Treatment_labels 3 "3. ENV", modify
label def Treatment_labels 4 "4. SOC*ENV", modify