Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2019, 12:12 PM
MaineLady MaineLady is offline "Duplicate" Chart Labels Windows 7 32bit "Duplicate" Chart Labels Office 2013
Advanced Beginner
"Duplicate" Chart Labels
 
Join Date: Sep 2014
Posts: 52
MaineLady is on a distinguished road
Default "Duplicate" Chart Labels

Can someone tell me why labels are showing up twice on D3?


Thank you, in advance...


Janice
Attached Files
File Type: xlsx Charts.xlsx (72.6 KB, 8 views)
Reply With Quote
  #2  
Old 03-20-2019, 07:42 AM
MaineLady MaineLady is offline "Duplicate" Chart Labels Windows 7 32bit "Duplicate" Chart Labels Office 2013
Advanced Beginner
"Duplicate" Chart Labels
 
Join Date: Sep 2014
Posts: 52
MaineLady is on a distinguished road
Default

First time I've logged into this forum and didn't get some help...
Reply With Quote
  #3  
Old 03-20-2019, 11:21 AM
ArviLaanemets ArviLaanemets is offline "Duplicate" Chart Labels Windows 8 "Duplicate" Chart Labels Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

When you delete last chart and create a new one, what happens?

Before this, maybe another thing worth to try out: Save the file with another name, and then save the old one over with new one. I am not sure with latest versions, bot with older versions this was a way to get rid of old information Excel did keep hidden somewhere. When it works yet, the size of file must be considerably less after that.

It looks like Excel gets same data for this region (P135:P149) twice somehow.
Reply With Quote
  #4  
Old 03-20-2019, 11:31 AM
MaineLady MaineLady is offline "Duplicate" Chart Labels Windows 7 32bit "Duplicate" Chart Labels Office 2013
Advanced Beginner
"Duplicate" Chart Labels
 
Join Date: Sep 2014
Posts: 52
MaineLady is on a distinguished road
Default

Thanks... I deleted the chart and recreated it... Problem went away.


I update these charts on an annual basis... I always save the previous year's file with a new name, enter the new data and I'm good to go. Last year's file was fine. Something got messed up when I saved it with a new name for this year. Whatever it was, I figured it out on my own.


Thank you.
Reply With Quote
  #5  
Old 03-21-2019, 12:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline "Duplicate" Chart Labels Windows 7 64bit "Duplicate" Chart Labels Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. civilcervant Excel 3 06-12-2017 07:27 AM
"Duplicate" Chart Labels Update Fields reverts all labels to "Next Record" bsn321 Mail Merge 3 12-09-2016 05:21 AM
Chart needs #N/A, SLOPE function needs "q" ue418 Excel 0 10-16-2012 01:46 PM
"Duplicate" Chart Labels Deleting duplicate emails - where is "table type view"? PaulNic Outlook 1 08-14-2011 10:08 PM
"Duplicate" Chart Labels How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft