ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   parameter the axis of a graph (https://www.excelbanter.com/excel-programming/427303-parameter-axis-graph.html)

Clement[_2_]

parameter the axis of a graph
 
Hi everybody!

I'm using php, and COM to create an excel file (i use the function "visual
studio". I have created a graph with my data, and it looks like that :

$selection1 = $sheet-range("E2","F3");
$graph = $sheet-chartobjects-add(400, 20, 350, 250);
$graphique = $graph-Chart;
$graphique-SetSourceData($selection1, "xlRows");
$graphique-type=4;

It works pretty well, but i need to give parameters to the graph, to
describe the axis (abscissa and ordinate).
Does it exist a function like that : "setAbscissaAxis(name, range)" ?

Thanks for your help.
Sorry for my poor english.

Clement.


Clement[_2_]

parameter the axis of a graph
 
I've find a temporarily solution.
I have my array like that :

A | B
NameTitle1 | NameTitle2
Value1 | Value 2
Etc.

If I choose the two columns, my graph is not the one i need, but if i put an
empty cell instead of "NameTitle1" in "A1", the graph is better, with the
column A on abscissaes, and the column B on Ordinates.

If you have a better solution tell me ;)





All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com