Member Avatar for geraldike

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,

Edited by Reverend Jim because: wrong forum
  • 3 Contributors
  • 2 Replies
  • 175 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by ddanbe
Member Avatar for Reverend Jim

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.

Member Avatar for ddanbe

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.