Trying to Make Dynamic Chart

Hi I'm trying to make a dynamic chart and using this tutorial http://peltiertech.com/Excel/Charts/...umnChart1.html

And everytime I write this part into the formula bar it won't accept it as in hit enter or the tick and nothing happens

Please Login or Register  to view this content.

Can you provide your working sample so I can see what you have tried and how you set it up?

Try this...

Right click chart >> Select Data

Select the Units series >> Edit

Series values >> =Sheet1!$B$2:$B$7 >> Change to >> =Sheet1!ChartValues

Tip for doing this >> when in the Edit series dialogue box >> erase what is in the series value >> select F3 >> double click on ChartValues >> OK

Now click on the Axis >> Edit

Series values >> =Sheet1!$A$2:$A$7 >> Change to >> =Sheet1!ChartLabels

You are welcome and thanks for the feedback.

========================================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save