ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Why do OWC charts aggregate data when Excel doesn't? (https://www.excelbanter.com/charts-charting-excel/62048-why-do-owc-charts-aggregate-data-when-excel-doesnt.html)

Floored

Why do OWC charts aggregate data when Excel doesn't?
 
I have charts in Excel that have in excess of 200 values on one axis. They
are dates, and each value is for a day. When I create a chart in Excel, it
looks fine when I run it in Excel, but when I save it as an interactive HTML
file, the chart ends up grouping the data into a range of dates (eg 14 days),
and then the sum of the values.
How can I get the HTML/ActiveX chart to show me the same thing as in Excel.
I've been poring over the generated XML, but can't for the life of me figure
it out!
Anyone know what the problem could be, and how to remedy it?


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com