Give the Maximum of a graphic

M

MariPip

New Member
Joined
Jul 16, 2014
Messages
29
Hi :)
I have a graph in an excel sheet that depends on several formulas and data...
What I need is a code or a formula which asignes Cell B38 the Maximum of the function in the chart
??
Can anyone help me with this??
Thank you!!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Hi MariPip - Have you tried placing the equation: =Max(A1:A30) in cell B38? For A1:A30 put in the range you want to find the max of. Hope this helps get you started.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
VBA - Creating a Dashboard with Charts including data changes
Replies
1
Views
217
Jon Peltier
J
D
  • Question Question
Using VBA to determine Maximum Values in an Excel Spreadsheet
Replies
4
Views
470
Artik
Artik
F
  • Question Question
Nested IF functions
Replies
5
Views
323
shift-del
shift-del
W
  • Question Question
Charting range as a vertical bar chart
Replies
1
Views
181
felixstraube
F
M
  • Solved
Alternative way for long formula typed with IFS
Replies
5
Views
462
Alex Blakenburg
A

Forum statistics

Threads
1,223,243
Messages
6,170,967
Members
452,371
Latest member
Frana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top