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
SGIII wrote:
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've no idea whaat I was doing there but it seems to have done the trick.
I'm very very grateful for the time and trouble you have both taken on this what must seem a trival issue.
Thank you very very much. 🙂
Badunit wrote:
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.
When I unhide the two rows all is well!!! 🙂
The reason why I hid the first two rows was because A1 & A2 were reference cells that cells A4 onwards used to "look right". It was Jerry that kindly showed me how to write the formula that produced the dates in Coumn A.
His advice was:-
The first date is seeded into A2. There are three Header Rows.
The first Body Row, Row 4, contains:
=$A$2+(ROW()−4)×7&" - "&$A$2+(ROW()−4)×7+6
Fille Down.
You guys have the patience of a saint!!!
Many thanks
2D Chart Issues
