Charting only the specified dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I am using Excel 2002 SP-2 on Win2k Prof.

Q1.
I have the following data for testing

Date Val
20/09/04 2
21/09/04 4
22/09/04 8
23/09/04 16
24/09/04 32
27/09/04 16
28/09/04 8
29/09/04 4
30/09/04 2

And, when I simply chart it the chart shows missing dates on X-Axis, 25/9/04
and 26/9/04, with interpolated values each, according to either end of the
closest values (24/9/04 and 27/9/04). Why does this happen? How can I turn
this on/off?

Q2.
In relation to Q1, I try to create PivotChart and this time need
interpolated values for dates not specified in PivotTable. How can I do this?

Thanks for your time
 
Q1: With the chart selected, select Chart | Chart Options... | Axes
tab. Set the type of the Category (X) Axis to 'Category'.

Q2: I don't believe a PivotChart offers the above option. You can
create a non-PC from the PT data.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Utf-8?B?VGV0c3V5YSBPZ3VtYQ==?=" <Tetsuya
(e-mail address removed)> says...
 
Back
Top