Knowledge Varsity

BUSCOM Mini Case 3.5

Welcome to KnowledgeVarsity Forum! This Forum is to answer your queries regarding question text and its instructions for this specific question. Please take a minute before posting a question and see if you can find an answer to your question. If not, please post your question. The Forum moderator will respond very soon!

In Mini Case 3.5, I am creating a scatter plot. The values for x-axis (which will be labeled "GDP Growth Rate) were automatically input as years (A4-A9). I cannot change my values to B4-B9. It is greyed out when I try to change it using “chart filter.” I am unsure how to fix this. Thank you.

Try the steps given below:
(1) Select chart
(2) Go to Ribbon Chart Design and click on select data icon under the Data group
(3) A popup with more options shows up (see image attached)
(4) Click edit and select the cell range for X axis
image