openyxl reading existing file - missing charts

[CM]

Hi,

I have made an xlsx file with data in A1,A2,B1,B2 and then make a Column chart (tried clustered column and stacked column).

When I open then save that template. The data shows in A1,A2,B1,B2 but the graph is not visible.

Literally my code is:

#!/usr/bin/python3

from openpyxl.chart import BarChart, Series, Reference

from openpyxl import load_workbook

wb = load_workbook('/tmp/excel.xlsx')

wb.save("/tmp/new.xlsx")

I copied the example from:

https://openpyxl.readthedocs.io/en/stable/charts/bar.html#vertical-horizontal-and-stacked-bar-charts

and it makes the charts fine, but that's making a new one rather than rendering an existing one. 

Can anyone suggest why the graph is not rendering? 

[Charlie Clark]

You mean that a chart in your template file is no longer visible after
you process this with openpyxl? It's unusual if there is also no
exception but without the file it's not possible to say.

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

[CM]

Thanks Charlie

See attached the template file I am using (excel.xlsx) and also the file that openpyxl gives me once I save it.