Volume-Price chart

[Igor]

Hello

I did a volume/price chart recently. Everything was fine till I had to
connect points of price (line) series. Because the data was not continuous
(the chart showed sales of wheat in a specific period of time, but sales
took place only every second or third day) the Excel option to automatically
connect points was disabled (in 2003 and 2007). How can I connect them than?

Kind regards

 

[Bernard Liengme]

Type =NA() in the empty cell; they show as #N/A
The chart engine ignores them.
best wishes

 

[Igor]

Thank you. It is just what I wanted.

Type =NA() in the empty cell; they show as #N/A
The chart engine ignores them.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email