Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Chart name as the text from a cell.
Hey everyone,
So I have this code that scrolls through each column and uses each column as the y-axis and outputs a different chart with each increment. I was able to set up the title of each chart so that it shows the heading of each column as the title, but now I want the tab on the bottom of the chart to have this same title (which was obtained from the first cell of each column). This is the code I have for the title of each graph and it works fine : ActiveChart.SeriesCollection(1).Name = "=Sheet1!R1C" & C 'C refers to the column index The title is "Protein 1," which is located in Row 1 Column C. But for some reason when I tried to use this code to change the tab name of each chart, it didn't work: ActiveChart.ChartTitle.Parent.Name = "=Sheet1!R1C" & C Instead of displaying "Protein 1" on the chart tab on the bottom, it displays: =Sheet1!R1C4 'The C value works and increments, but for some reason it doesn't see the reference to output the text of the first row, 4th column cell. Any ideas would be greatly appreciated! Thanks, Sareh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Chart name as the text from a cell.
Idea - Not Solution Change ActiveChart.ChartTitle.Parent.Name = "=Sheet1!R1C" & C to ActiveChart.ChartTitle.Parent.Name = Sheet1!R1C.text & " " & C -- mpeplow ------------------------------------------------------------------------ mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812 View this thread: http://www.excelforum.com/showthread...hreadid=562177 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the Chart name as the text from a cell.
Sorry, Ignore my last post. Basically you have your title enclosed wit "" which usually tells the program to 'treat as string' you need t have a non-text refernce or create a new text variable to store you string in. I know this does not solve your problem but I hope that you go something out of it -- mpeplo ----------------------------------------------------------------------- mpeplow's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread.php?threadid=56217 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting rows to autofit wrapping text in a cell | Excel Discussion (Misc queries) | |||
Setting up a cell that contains text and a data reference? | Excel Worksheet Functions | |||
Setting spaces between text in a cell | Excel Programming | |||
Setting text as a background in cell | Excel Worksheet Functions | |||
setting cell contents to text using C# | Excel Programming |