Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart.
Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are plotted in thesame graph.
Thanks,
geraldike
0
Newbie Poster
Recommended Answers
Jump to PostThis does not belong in the vb.net forum. I've moved it up to the Software Development level and added appropriate tags for searching.
All 2 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
This does not belong in the vb.net forum. I've moved it up to the Software Development level and added appropriate tags for searching.
ddanbe
2,724
Professional Procrastinator
Featured Poster
When you can avoid VBA macros, avoid them. Excel has a great set of worksheetfunctions, among them : MAX and INTERCEPT. Hope it helps.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.