Creating a dynamic chart

[chammy88]

Hey guys,

I've never created a chart using VBA but have no found the need to do so. It's a bit of a sticky question.

I need a chart with one series being a bar chart on the primary vertical axis and the other series being a line graph on the secondary vertical axis. The series length can change depending on the day but both series will always have the same length on that day.

Any help is much appreciated!

 

[cyrilbrd]

Hi,
what version of Excel are you using?
also could you post a sample of your raw data? which ones would be the bars and which one would be the line?