Hello:
I have a simple line chart with a data table displayed below it using Chart Tools > Layout > Data Table > "Show Data Table w/ Legend Keys".
My data begins in the 30,000 range and goes up to around 50,000 range. I was able to edit my axis to display in thousands with a min value of 30.
How can I change my data table values to reflect the same. So for example if January shows 33,427 I just want the value in the data table to show 33.
Thank you
bump..........thanks
Format the cells of that data to Custom > 0,
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
So in the Custom "Type" field actually type "> 0,"?
No, just 0, no quotes just
0,
Hope that helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks