View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart with merged rows

I asked in your previous thread which data you wanted to plot where in what
kind of chart. This doesn't answer my question, only restates the initial
problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
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 !