• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Charting (VBA)

nagovind

Member
I need to represent a x-y scatter curve in a different way that is i need THICK line instead of standard available thickness


Actually the thickness should look like hatching pattern


I even tried by copying and pasting a image into the chart poits...but as my chart is constructed by more than 10000 x-y coordinate the same times the image is copied in chart which is taking more memory and time and at the same time it is taking more time
 
Navogind

You could use a Stacked Area Chart

setup say 2 dummy ranges

Range 1 = Value + 2% of Maximum Value of the whole range

Range 2 = Value - 2% of Maximum Value of the whole range

This will give you a line 2% either side of where it should be

Make the bottom area transparent (No Color)

Change the top area to have whatever fill type you want

Change the 2% to suit your needs
 
Hi Hui

Thanks for your reply

But i am not getting you 100% (i am understanding the method but unable to implement)

Actually i have many other curves in the same chart (say 9 curves) which is of Scatter type only


If it is possible by any means to send a excel sheet attachment, explaining my issues it is better
 
Hi nagovind,


See previous post on attaching samples


http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi chippy

thanks for your assistance


Please refer to the attachment in rapidshare site to have a clarity in my Query


Please do the needful ...Hui & chippy


http://rapidshare.com/files/387341720/Excel_Charting_Govind.xls.html
 
Hi Nagovind,

You have an interesting problem

You need to use a scatter chart, need to fill between the lines and need logrithmic axis

What I suggested earlier won't help as you need to use a scatter chart to use logrithmic axis.


Have a look at

http://peltiertech.com/Excel/Charts/VBAdraw.html

there is some code there for filling below a scatter chart line
 
Thanks Hui


Frakly speaking i even come across the above mentioned link by u; but i felt difficult..

but i wil try my best and come back

thanks for u r assistance


Thanks & Regards

Govind
 
Back
Top