create charts in excel using (python,perl)(linux)

1
votes

I need to generate chart/graph into Excel sheet from data present into Excel sheet. I am using python in linux environment. I have gone through below question but did not find any answer.I am using python 2.7 in linux enviroment. I am flexible to use perl also if we have any solution.

use python to generate graph in excel

How to generate Excel spreadsheets with embedded graphs?

(Tried with openpyxl :Graphs in xlsx File overwrite by openpyxl)

3
c++pythonperlpython-2.7
What is your question? - DevSolar
Need to create graph from Excel sheet data in Excel using python or perl - user765443
What have you tried? What exactly didn't work? -- This is a Q&A site (as in "why does this function x() not return the expected value"), not a "solve my programming assignment for me" site (as in "I need this done, please post code"). - DevSolar
Ya I have tried with openpyxl and found that xlwt and openpyxl both do not support the graph creation - user765443

3 Answers

1
votes

The Python module XlsxWriter supports charts.

0
votes

Taken from your other question...

Here is the documentation on how to create a chart in openpyxl

The example is a little broken, compare to this instead.

values = Reference(ws, (1, 1), (1, 95))
series = Series(values, title="Sample" )
chart = LineChart()
chart.append(series)
ws.add_chart(chart)