Dear All,
Is is possible to manage the color of each bar of a Excel Bart Chart created with "MakeBarChart"?
Thank you for your answer
Noémie
Search found 5 matches
- Tue Oct 02, 2018 8:45 am
- Forum: XLSReadWritwII 6
- Topic: Chart series color
- Replies: 1
- Views: 4101
- Tue Oct 02, 2018 8:43 am
- Forum: XLSReadWritwII 6
- Topic: Stacked bar 100% chart
- Replies: 2
- Views: 4548
Re: Stacked bar 100% chart
Dear Larsa, Thank you for your answer, I managed to find a solution : Procedure CreateChart; Var RCells : TXLSRelCells; ChartSpace: TCT_ChartSpace; Begin RCells:=xlsReadWrite[1].CreateRelativeCells; //Chart Area RCells.SetArea(2,7,5,8); //Chart creation ChartSpace:=xlsReadWrite[1].Drawing.Charts.Mak...
- Fri Jul 20, 2018 9:27 am
- Forum: XLSReadWritwII 6
- Topic: Stacked bar 100% chart
- Replies: 2
- Views: 4548
Stacked bar 100% chart
Dear all, I'm using TXLSReadWriteII to create XLSX files where I would like to create chart. I am currently running some tests and I have trouve selecting the exact type of chart I need. Here is my small sample . Procedure CreateChart; Var RCells : TXLSRelCells; ChartSpace: TCT_ChartSpace; Begin RCe...
- Thu Feb 02, 2017 9:12 am
- Forum: XLSReadWriteII 3/4/5
- Topic: column order with XLSDBRead
- Replies: 2
- Views: 6483
Re: column order with XLSDBRead
Hello Larsa,
Thanks a lot, That would be great.
Regards
Noémie
Thanks a lot, That would be great.
Regards
Noémie
- Mon Jan 30, 2017 3:58 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: column order with XLSDBRead
- Replies: 2
- Views: 6483
column order with XLSDBRead
Dear All, I am using TXLSDBRead5 linked with TXLSReadWriteII5 to export the content of a dataset to an xlsx file. It works like a charm. I would like to know if it is possible to change the order of the column in the xls file. As I can see, the current order is the field order in the dataset query, ...