Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
870
Column chart with a time x axis (part of a composite chart)
posted

I am trying to replace functionality we have with other charting products and am having real problems getting it to work with WinChart.

The business problem I am trying to solve is the following:

An investment portfolio is made up of instruments that come from multiple sectors.  Over time the portfolio makes and/or losses money.  Each of the sectors make or loose money over time as well.  I need to be able to chart both the portfolio changes in value over time as well as the individual sectors.

Traditionally, this is done using a combination of line charts and bar (you call them column) charts.  The lines are for the change in value of the portolio and the columns show the change in value of the sectors.  So, for the line, there is one point on a day, for the sectors, there is one for each sector.  With a portfolio made of three sectors, it would be a line chart with three columns for each day.

In WinChart, column charts do not seem to support date/time as an x axis at all.  When implementing a composite where rather than a date we use a string, the major/minor grids for the two charts don't line up (I assume because the are fundementally different).  If the labels for the chart are used from the line (the one with the dates), even if you tell the chart that the interval is one day, it shows multiple lables for the same date:

And the data points for the lines are not centered in the space taken up by the columns.

For background, this is being implemented using series and additional data streams can be overlayed onto the chart as well.

Any suggestions would be appreciated as this is a pretty basic kind of thing and I can't believe it is this hard with WinChart.

Dana

Parents Reply Children
No Data