How to create a chart in Excel Worksheet with specific cell data that is not adjacent.

Question

I created this spreadsheet in Excel Google Docs, but I can't seem to create a y axis through setup to chart goal 1 progress and date of sessions over time. I don't seem to have a y axis available in setup, only the x axis. How can I go about this? Do I have to "query" specific cells if they are not adjacent to each other? I have tried selecting with "command" specific cells and highlighting them, but it doesn't work. What am I doing wrong?

Answer 1

Hi @Carolyn Stier

Thank you for reaching out to the Microsoft Q&A Forum. 

Please understand that our forum is a public platform, and we will modify your question to cover your organization domain name in the description. Please notice to hide these personal or organization information next time you post error or some information to protect personal data. 

From your description and screenshot, it looks like you're currently working in Google Excel rather than Microsoft Excel. Since I don't have access to Google Excel environment to test directly or provide exact steps for that platform. 

However, I did try to reproduce your scenario using Microsoft Excel. I was able to select non-adjacent cells and create a chart that includes both X and Y axes. If by "Y axis" you're referring to plotting the progress values over time, that kind of setup seems to work fine in Excel based on my testing.

I hope this Excel example is a helpful reference. For more detailed guidance specific to Google platform, please contact Google’s Help Center or its forums. 

If you have any further questions or concerns, please don't hesitate to reach out.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".      

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.