Mix 2 different chart type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Quick question. Is it possible to mix Column and Line in the same chart? (2D
chart) I want to show Opened request and Closed request with column and the
backlog with line.

Any ideas?
 
I have figured out my-seft. It is working.

Yes. Essentially it involves adding another a line chart over the column
chart and making the background of the top chart (line chart I assume)
transparent. To make the line chart background transparent, you need to
click once on the line chart and right click and select Fill/Back Color =
Transparent. This property doesn't seem to be available under the chart
options. To get this to work properly, you may need to turn off the
automatic scaling functions, as each chart would change independantly of
the other. You may have to play around with it a bit, but it is doable as
long as your ranges you are charting don't vary too much. Another option
is to have 2 Y axis, one on the left for Column, and one on the right for
your lines. As long as the base line (zero intersect) are on the same, you
could try this to.
Good luck
db
 
Back
Top