Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have several data points that are the result of a pivot-table and I'm
trying to plot them in a pivot-chart (I can easily get them out of the pivot table if the graph format is not supported for pivot-charts). Here's an example of the data: 2005/01/15 2005/02/22 2005/03/18 2005/05/20 X 16 18 22 12 Y 4 6 3 2 Z 14 19 12 34 What I'd like to do is plot the data (preferably on a line chart) such that the dates are on the x-axis and spaced as they would be on a calendar and not simply as 4 points on a chart. e.g. in the example above there would be 4 points per category but the points would be at varying intervals on the date axis as they are not equidistant in time. Is this possible? All help appreciated? Regards, PK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Charting data from many files | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting challenge/query | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |