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?