 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2006line chart over time
Hi, My data looks like this: Mon Tue Wed Thu Fri Sat Sun 06/26/06 5 4 3 6 3 1 1 07/03/06 1 2 4 9 0 0 2 07/10/06 0 1 1 1 2 2 1 07/17/06 8 6 4 3 0 1 0 07/24/06 5 5 3 0 0 2 3 ... I know how to chart data against time if I have just one column of dates and one of data, but how can I chart the above data as one series? Thanks for any help, grimholtz grimholtz - Maybe you could try to get the original raw data instead of this summarized table. - Mike http://www.mikemiddleton.com > Hi, > [quoted text clipped - 13 lines] > Thanks for any help, > grimholtz > Maybe you could try to get the original raw data instead of this summarized > table. Hi Mike, Well, I have the raw data. What I posted isn't a summary. Let me ask the question a different way. Say I have daily stock price data for stock symbol ABC. If I want a line chart showing price vs. time, how can I do that? Assume I have 52 rows each with 7 columns. Each column is a day of the week. Each row is a week of the year. Thanks for reading, grimholtz What Mike means is that the data is not properly set up to plot as a single series. To show price vs date, you need a column of dates and a column of prices. Charts can only plot the data that's available; they can't guess that you want to offset each adjacent column by an extra day. You need to unsummarize the data. Although you say your data isn't summarized, it really is, because it is as if the daily data has been pivoted so that the week beginning date is in the first column and the days of the week across the first row. Maybe you didn't use a pivot table to summarize it, but it's summarized. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ >> Maybe you could try to get the original raw data instead of this >> summarized [quoted text clipped - 10 lines] > Thanks for reading, > grimholtz |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.