Python-pptx line chart error -


newb here getting python , ran issue that's beating me down. have following excerpt of python code create ppt slide existing template. layout , placeholders correct can't run data listed below (x, y_in, & y_out). appreciated.

x = [datetime.datetime(2017, 8, 4, 15, 5, tzinfo=<fixedoffset u'+00:00' datetime.timedelta(0)>), datetime.datetime(2017, 8, 4, 15, 10, tzinfo=<fixedoffset u'+00:00' datetime.timedelta(0)>), datetime.datetime(2017, 8, 4, 15, 15, tzinfo=<fixedoffset u'+00:00' datetime.timedelta(0)>), datetime.datetime(2017, 8, 4, 15, 20, tzinfo=<fixedoffset u'+00:00' datetime.timedelta(0)>)]  y_in = [780993, 538962, 730180, 1135936]  y_out = [5631489, 6774738, 6485944, 6611580]  prs = presentation('network_utilization_template_master.pptx')  slide = prs.slides.add_slide(prs.slide_layouts[2])   placeholder = slide.placeholders[17] chart_data = categorychartdata() chart_data.categories = x chart_data.add_series(y_in) chart_data.add_series(y_out)  graphic_frame = placeholder.insert_chart(xl_chart_type.line, chart_data) chart = graphic_frame.chart chart.has_legend = true chart.legend.include_in_layout = true chart.series[0-2].smooth = true  prs.save("network_utilization_" + today_s + ".pptx")

the compiler spits out following:

traceback (most recent call last):   file "/users/jemorey/documents/pptx-2.py", line 81, in <module>     graphic_frame = placeholder.insert_chart(xl_chart_type.line, chart_data)   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/shapes/placeholder.py", line 291, in insert_chart     rid = self.part.add_chart_part(chart_type, chart_data)   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/parts/slide.py", line 174, in add_chart_part     chart_part = chartpart.new(chart_type, chart_data, self.package)   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/parts/chart.py", line 29, in new     chart_blob = chart_data.xml_bytes(chart_type)   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/data.py", line 104, in xml_bytes     return self._xml(chart_type).encode('utf-8')   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/data.py", line 128, in _xml     return chartxmlwriter(chart_type, self).xml   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/xmlwriter.py", line 803, in xml     'ser_xml':      self._ser_xml,   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/xmlwriter.py", line 902, in _ser_xml     'tx_xml':     xml_writer.tx_xml,   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/xmlwriter.py", line 191, in tx_xml     'series_name': self.name,   file "/users/jemorey/library/python/2.7/lib/python/site-packages/pptx/chart/xmlwriter.py", line 121, in name     return escape(self._series.name)   file "/system/library/frameworks/python.framework/versions/2.7/lib/python2.7/xml/sax/saxutils.py", line 32, in escape     data = data.replace("&", "&amp;") attributeerror: 'list' object has no attribute 'replace'

david zemens quite right in comment. series has name, appears first argument chartdata.add_series(). name appears in legend next line color series , appears column heading data series. adding in should next step.

something like:

chart_data.add_series('mb in', y_in) chart_data.add_series('mb out', y_out)

Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more