hivebuzz (74)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingCongratulations @kenneth7799! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : You received more than 10 upvotes.…kenneth7799 (41)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingPaula, thank you so much for this. It answered my query and I have also responded via email. Thanks again. Kennytheexcelclub (67)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingOk I got the file by email and returned with the following Well, that took a little creativity, but I think I have a solution. First, let's look at the problem. If you go to…theexcelclub (67)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingI need to try and replicate the problem, you can share a dropbox/onedrive/google drive link, or, I just sent you an email, maybe you could email me a sample?kenneth7799 (41)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingI have created an example file to try and clarify the issue. Not sure if this can be uploaded?kenneth7799 (41)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingIt is a range of roughly 180 cells say A1:P19. The data changes for each metric. The first metric chosen returns 180 cells formatted as a number (no decimals). The second…theexcelclub (67)in Excel For All • 5 years agoRE: [SOLVED] Chart Data FormattingI am a little confused. Are all the data types in the same column? Can you share an example?