Y
Young-Hwan Choi
Hello.
I have three questions, and they are all related to a chart.
Q1. Is it possible to define a line weight with a specific thickness such as
0.01 inch instead of xlThick, xlThin, etc. ?
Q2. Is it possible to use a dashed line in a chart for a large amount of
data to distinguish it from a solid line? It seems that Excel generate a
dashed line between two points, not from the overall shape. So, when there
are larger points, it cannot distinguish it. The distance between two points
are too narrow. So, it looks like a solid line. Someone recommended to use a
Mod function to change the number of data points. However, when I used it, I
lost some important part, which varies along the data points.
Q3. Is it possible to change the marker frequency other than using Mod
function? This is similar to Q2.
thanks.
I have three questions, and they are all related to a chart.
Q1. Is it possible to define a line weight with a specific thickness such as
0.01 inch instead of xlThick, xlThin, etc. ?
Q2. Is it possible to use a dashed line in a chart for a large amount of
data to distinguish it from a solid line? It seems that Excel generate a
dashed line between two points, not from the overall shape. So, when there
are larger points, it cannot distinguish it. The distance between two points
are too narrow. So, it looks like a solid line. Someone recommended to use a
Mod function to change the number of data points. However, when I used it, I
lost some important part, which varies along the data points.
Q3. Is it possible to change the marker frequency other than using Mod
function? This is similar to Q2.
thanks.