LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting values in a bar chart Eric D Charts and Charting in Excel 4 April 17th 06 04:44 PM
Combine data rows in Pie Chart Jayntree Charts and Charting in Excel 1 March 16th 06 09:15 AM
Chart data from merged cells. aftamath Excel Discussion (Misc queries) 1 September 28th 05 08:51 PM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"