Dynamic Chart

[thong]

Hello All,

I have a workbook that have a dynamic chart using offset function, my problem is if I will used the scatter type of graph my horizontal axis is not dynamic like the line type. Is there any work around so that I can used it in scatter type?

Please find attached file for your reference.

Thank you so much in advance.

 

[Luke M]

I'm not sure what you're asking to do...the point of a line vs. XY is whether you want to plot everything equally, or at their exact point. CHeck out your x-axis on line vs. scatter:
Line

Scatter


The line chart placed all your items equidsitant, so 1 and 2 are same distance apart as 6 and 8. The Scatter does the (correctly) where all numbers are correct distance apart. This is why the charts look different.


As to why it's not actually dynamic, you didn't put the named ranges into the Scatter chart. It still has static ranges.

 

[thong]

Hi Luke,

I changed my name ranges for my scatter, but my problem now is my horizontal axis, if I will add values to column A (21) column B(99) column C (97) my horizontal axis showing 23. Is it possible to show exactly the same value that I put to column A?

Thank you.

 

[p45cal]

On the Scatter sheet of the attached I have automated the max of the x-axis to be the max of the timelabels named range.

 

[thong]

Thanks p45cal. It works like a charm!

 

[thong]

Hi p45cal,

Sorry I need more guidance... I was trying to rename my scatter worksheet, and when I put values Im getting this error "Microsoft Visual Basic Runtime Error '13', Type Mismatch"

Please help me.

Thank you

 

[p45cal]

I was trying to rename my scatter worksheet, and when I put values its saying debugger problem. Please help me.

Really?! On the file I attached?

It might be getting confused with Names; in Name Manager, delete any names with #REF errrors perhaps?

 

[thong]

Hi p45cal,

I did removed all with #ref errors in the name manager but still giving me the error. Please find attached file.

 

[p45cal]

You've not only deleted a sheet but also changed the name of a sheet too!
Change:
ChartObjects("Chart 1").Chart.Axes(xlCategory).MaximumScale = [max(Scatter!Timelabels)]

to:
ChartObjects("Chart 1").Chart.Axes(xlCategory).MaximumScale = [max(Comparative!Timelabels)]

 

[thong]

Hello,

Its working now.

Thank you.