Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with merged rows
Another question for EXCEL gurus !
I have a chart with 56 rows (corresponding to 56 weeks in a year), each of which is composed of merging 7 rows (corresponding to 7 days/week). How can I get a graph with the values in these merged columns ? Selecting these and clicking the chart icon does not produce anything ! X-axis C, Y-axis - D -------------------------------------------------------------------------------- A B C D --------------------------------------------------------------------------------- 13. Aug. Sunday 33 23:55:00 14. Aug. Monday 15. Aug. Tuesday 16. Aug. Wednesday 17. Aug. Thursday 18. Aug. Friday 19. Aug. Saturday --------------------------------------------------------------------------------- 20. Aug. Sunday 34 30:55:00 21. Aug. Monday 22. Aug. Tuesday 23. Aug. Wednesday 24. Aug. Thursday 25. Aug. Friday 26. Aug. Saturday ---------------------------------------------------------------------------------- Thank you ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Combine data rows in Pie Chart | Charts and Charting in Excel | |||
Chart data from merged cells. | Excel Discussion (Misc queries) | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |