M
mbobro
Hi,
I need to make a chart that wil consist out of two series. The firs
one should be shown as a column, while the second as a line drawn o
the given height just on the column. This column with the lin
represents one wave of measurement (see the attachment)
This data is going to be collected in waves and of course the char
should be also updated. If it was a regular column chart I could us
VBA to move the data columns to the left and update only the last wave
Unfortunately I can't find a chart type that will support such
illustration. The only solution I have found is to manually draw
horizontal line on the proper column. Of course this solution could no
be accepted as it is difficult to be automated.
What would you suggest?
Regards,
Mik
Attachment filename: complex chart .xls
Download attachment: http://www.excelforum.com/attachment.php?postid=48229
I need to make a chart that wil consist out of two series. The firs
one should be shown as a column, while the second as a line drawn o
the given height just on the column. This column with the lin
represents one wave of measurement (see the attachment)
This data is going to be collected in waves and of course the char
should be also updated. If it was a regular column chart I could us
VBA to move the data columns to the left and update only the last wave
Unfortunately I can't find a chart type that will support such
illustration. The only solution I have found is to manually draw
horizontal line on the proper column. Of course this solution could no
be accepted as it is difficult to be automated.
What would you suggest?
Regards,
Mik
Attachment filename: complex chart .xls
Download attachment: http://www.excelforum.com/attachment.php?postid=48229