Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: Bardonicloud
Bardonicloud Author
User level: Level 1
47 points

Chart Source Data format from Tables not respected on Y1 Axis?


I used to have columns E and F set as “dollars” currency (which are for values that will display on the Y axis of a chart -- my red and blue lines -- but I changed E and F to a “number” format.


Yet, when I go to chart settings and set Y axis as “same as source data” it still uses dollars on Y1?


What have I missed? Pls see my first 3 images:









Also, I seem to have 4 decimal places with one of the 4 charts which has respected the fact I want the Y1 axis set as a "same as source" from a column whose values are also set to "number." Noe sure how to get it to 2 decimal places? Pls see last 4 images.







Cheers,,


MacBook Pro 15″

Posted on Apr 1, 2023 1:08 AM

Reply
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
28,534 points

Posted on Apr 17, 2023 6:07 PM

This appears to be a line chart (not a scatter chart). The one anomaly I see is that "11800" is not all the way to the left on the X axis. There appears to be one category before it, meaning it appears you included the row above 11800 in your chart data. To the best of my knowledge, the "same as source data" setting gets its information from the top cell of the leftmost series. If the chart includes the blank cell in the row above, it is possible that cell is formatted just like you see on the chart. My recommendation would be to Edit Data References and remove that row from the chart.


There also seems to be one category extra on the right side but that one is not a problem.

View in context

Similar questions

2 replies
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
28,534 points

Apr 17, 2023 6:07 PM in response to Bardonicloud

This appears to be a line chart (not a scatter chart). The one anomaly I see is that "11800" is not all the way to the left on the X axis. There appears to be one category before it, meaning it appears you included the row above 11800 in your chart data. To the best of my knowledge, the "same as source data" setting gets its information from the top cell of the leftmost series. If the chart includes the blank cell in the row above, it is possible that cell is formatted just like you see on the chart. My recommendation would be to Edit Data References and remove that row from the chart.


There also seems to be one category extra on the right side but that one is not a problem.

Reply

Chart Source Data format from Tables not respected on Y1 Axis?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up