Hello everyone. I have been searching online at multiple forums and cannot seem to find the answer to my exact situation. I am trying to create a dynamic Chart title. I have four charts that are on a separate page that change dynamically based on the information on a separate worksheet. When I select the title I can only edit the text box that it is in. I cannot access the formula bar and in fact, the entire formula tab has everything grayed out. I at all possible I want to avoid having to use vba code to make this work as I have found that it slows down the worksheet on older machines that we have here. I am using Excel 2010 and have tried using the =cell reference and &cell reference to no avail. Thanks in advance for your help!
Last edited by foxgoku; 01-25-2012 at 11:12 AM.
Hi foxgoku,
Welcome to the forum.
Do you want chart title via formulas? Yes this is possible, see the attachment.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Yes that is what I want, but I can't find where I can put the formula in to make this happen. When I click ton the actual text box for the chart title the formula box is inactive. I guess I just don't know the proper way to do this. Can you help?
Post duplicated from above.
Last edited by foxgoku; 01-23-2012 at 12:20 PM.
Hi foxgoku,
It is already done. If you check the chart, its title is coming from sheet 3 not from sheet 1 where it has all the data source.
For your quick reference, I have attached a screenshot image. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Hi foxgoku,
It is already done. If you check the chart, its title is coming from sheet 3 not from sheet 1 where it has all the data source.
For your quick reference, I have attached a screenshot image. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
DILIPandey thanks for all your help thus far. I mean I can't find where I can insert the formula on my worksheet. Also, when looking at your worksheet, I can verify that it is changing dynamically but I cannot find where the formula was inserted to make this happen. What I am looking for is a "How to" do what you did with that title so I can duplicate on my worksheets and future ones if need be. I simply cannot find the location where you put in the formula to make the title change dynamically.
Does this help?
http://www.andypope.info/tips/tip001.htm
Does this help?
http://www.andypope.info/tips/tip001.htm
Duplicate post due to forum malfunction
Unfortunately, no...This is what I was trying to achieve but I cannot access the formula bar for the Chart Titles like I mentioned in the OP. I would like to add something like =Data!$A$1&" "&Data!$C$2, =Data!$A$1&" "&Data!$D$2, =Data!$F$1&" "&Data!$H$2, and =Data!$F$1&" "&Data!$I$2. for the chart titles in the worksheet "graphs". How can I get this done?
TOI P1dB Template.xlsx
Your chart objects are embedded on a chart sheet so you can not access the formula bar.
Either move each chart to a worksheet and make the link before moving back the the chart sheet.
Or use VBA once to make the connects. Changing object index and cell range to suit.
Whichever way you do it you will need to use a holding cell to cope with the concatenation.activesheet.chartobjects(1).chart.charttitle.text ="=Data!P1"
Hi foxgoku,
See the chart on the data tab itself where I have moved one from the top right side of the charts and here it is taking the formula as in chart title.. rest you can do R&d..
Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Thanks guys that did the trick. One final thing that isn't too big of a deal. Is there a way to set the scaling on the graphs/charts to a specific cell? I'm looking at setting the scale based on what the input values are. If not no biggie. Thanks a bunch for that, I never would have thought it was because of being in that sheet.
You are welcome foxgoku..
As far as I know charts scaling does'nt allow formulas / references... though vba can be a solution.
Suggest you to come up with another post for this problem so that other can also get benefit out of it if they search it respectively. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey
+919810929744
dilipandey@gmail.com
Thanks everyone for the great help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks