I'd like to create a 2D bar chart of the following data with the Week Date Ranges along the bottom and the Cost along the Y. I can get the Cost to show on the Y axis but I can't get the Weekl Date Ranges to show along the bottom Does anyone know how I can include the Week Date Range underneath each bar?
Thanks
Easiest way is to convert column A to a header column (assuming "Week Date Ranges" is in column A). Right click on the "A" and choose "Convert to Header Column". Then make your chart.
When I right click on column A I don't get the "Convert to Header Column" option.
Then it is likely it is already a header column. As such, Numbers should have automatically used the text in column A for the X axis labels on your chart, just as you would have wanted it to.
To create the chart, select the data in the "Cost" column then choose a chart type. That should be all it takes. If that's what you already did, maybe just try it again. If that doesn't work, select the chart and look at the Format sidebar. Go to the Axis tab and click on X axis and look at the label references. If nothing is there you can select them from column A. In the screenshot below, I also set the labels to vertical.
It's showing the correct reference but it's not appearing on the chart😕
Well, I'm at a loss. Something is not working correctly. It is as if you have Category Labels set to "None" instead of "auto-fit".
I notice your first label is in A4 but it looks like it would be A2 in your screenshot. Any hidden rows or columns or anything else different about your table than what meets the eye in your screenshot? I'll try to duplicate the problem. I haven't been able to so far.
Try a new document and see if you can create a chart properly in it.
Hello, Schrodinger56,
You need the label references to start from A2, not A4.
Doubleclick on the first reference and a box will pop up like this (except I think yours will be missing A2 and A3):
Click so the cursor appears before the first reference in the box. Then double-click A3 in the table. Repeat for A2. Then accept with the green check mark. With luck, that will do it.
SG
The first cell is A4. There are 2 Hidden rows viz A1 & A2.
If you look at the Series tab in the format sidebar, what range is shown for "Value" in the series tab?
The chart works here, even with hidden rows (I have rows 1 through 3 as Header Rows and Column A as Header Column). Maybe you could post a screenshot showing all the cell references in the box that appears after you double-click Weekly Readings::Table 1::A4 in Label References:
SG
Hope this helps!!
That looks right.
And what do you show when, with chart selected, you click Edit Data References, and go here?
There should be one reference in there: Weekly Readings Table::E
SG
SGIII wrote:
That looks right.
And what do you show when, with chart selected, you click Edit Data References, and go here?
There should be one reference in there: Weekly Readings Table::E
SG
When I click Edit Data References all the cells in Column A are highlighted.
Assuming Cost is in column E, then you need the Data Value: to refer to that column, not column A. Try double-clicking in reference token in the Value box then click on the E column label to shift the reference to column E. Then double-click the reference token in Name: and click cell E3.
SG
I can now replicate the problem. Unhide rows 1 and 2. Row 1 is a header row and for some reason when you hide a header row it is causing this problem. Probably a bug in the app. If row 1 was a normal row, it would not cause this problem when hidden. Any reason why you need them hidden? Any reason why either needs to be a header row?
If I unhide 1 and 2, delete 1 (which makes 2 become 1), add a header row above 1, then hide them again, is exactly as before but the problem doesn't appear in the chart. I think you're best off not hiding a header row, though.
2D Chart Issues
