How to link Maximum value of Axis to cell in Chart - Excel?

karen_si_chen

New Member
Joined
Oct 28, 2005
Messages
4
Hi, can anyone help me with this problem? The X-axis of my chart is based on the current date. So it changed for each day. I need to some how link the maximum of X-axis of my chart to the particular cell which have value of current date. So once I updated that cells, the chart is also updated. Is this can be done in EXCEL????? (Currently I have to change the maximum value of the X-axis of my charts manually which is really painful) Please give any suggestion. Thanks in advance

Karen
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Karen

How about:
1) Link the chart data to a dynamic name which will change and select the data for the current date
2) Link the chart to a fixed range, and have that range populated dynamically based on the date.

Neither of these require the chart to be altered each day.


Tony
 
Upvote 0
Hi Tony,

Thanks for your comments. I also just found another way to do it. I download AutoChart add-in which is able to link the maximum or minimum of axis to cells.

Karen
 
Upvote 0

Forum statistics

Threads
1,217,753
Messages
6,138,416
Members
450,135
Latest member
IsidroGil

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