Hi I'm having a problem with making the graph for task 2. I'm using Excel online. As you can see in the image, money populates the vertical and horizontal axes rather than just the horizontal axis. I looked at the solution (first because I didn't understand which graph you were asking to be created) and copied the source and layout values exactly but money appeared on both axes. So I add the same source to the "category" field and the horizontal axis shows money in hundreds instead of hundred thousand (it showed in hundred thousand before adding a category field). If I remove the "value" field and keep the "category" field the whole graph disappears! How do I fix this?

It worked finally and I don't know why or what changed

you are working with money as a numerical so you should choose (histogram) as i see i think you insert (bar chart) instead of (histogram)

Follow this topic

Super learner

Last answered:

23 Mar 2023

Posted on:

22 Feb 2023

Problem with Task 2

2 answers ( 0 marked as helpful)

Super learner

Posted on:

26 Feb 2023

Posted on:

23 Mar 2023