Page 1 of 1

Create chart with XLSSpreasheet

Posted: Sun Jan 24, 2021 9:06 am
by TSASupport
Hi,
I cannot find a good example, nor can I find any documentation for creating a chart with the requirements that my client is asking for.
What they want is :
  • - a title at the bottom of the chart, with multiple lines
    - series that go from left to right , where the sample code only shows series from top to bottom
    - the series are taken from another worksheet
    - alter the with of barcode
    - text on the horizontal axis instead of numbers (sample code only show numbers from 1 to 12 for the months, we want the text 1= Jan, 2=Feb, ..)
    - some text on the vertical axis, beside the numbers, (the numbers go from 0 to 10 and the extra text could be something like 'kg')
    - etc.
The original code uses Excel to create different chart types, ..WorkBooks[0].Sheets.Add(0, , 1, xlChart), after that the exact Charttype is set.

Can you give me an example or some documentation?