Create chart with XLSSpreasheet

Questions and answers on how to use XLSSpreadSheet.
Post Reply
TSASupport
Posts: 1
Joined: Thu Jan 21, 2021 9:52 am

Create chart with XLSSpreasheet

Post 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?
Post Reply