I have a pie chart that is showing variables on my worksheet. the pie chart contains labels showing what the variables are. The problem that I am having is when i change the variables the pie itself changes but the labels do not. How do i set the labels to change and show the new contents of the variable fields?
Hi -
When you add labels, you can pick a data range for them. As the numbers in that range change, the labels should update. As for your particular problem, I can't tell from just your verbal description. Can you post a sample spreadsheet with any sensitive data removed and a couple examples of what you're expecting the results to be? To post a spreadsheet (not an image), select the Go Advanced button at the lower right corner of the Reply window. Scroll down until you see the hyperlink Manage Attachments. Select that and then use the buttons to browse to your file and the push the Upload button. Hit Close This Window and Submit Reply.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks