PDA

View Full Version : Solved: how to skip no dates data in chart



anandbohra
05-16-2008, 02:00 AM
hi friends

I have to create one chart. I get data from Stock Exchange so the data is as per trading days but when I plot the same excel keeps space for no date.

say my data is for 2,3,4,8,9,10 of may (2nd may, 3rd may & so on)
when i plot the above in chart excel itself give space for 5,6,7 which is missing.

pl tell me how to stop excel from doing so.


pl refer my attachment for clear view

Bob Phillips
05-16-2008, 02:19 AM
Select the chart, then righ-click to get a context menu.

Select Chart Options, then on the Axes tab, select Category under Primary
Category (X) Axis.

anandbohra
05-19-2008, 09:59 PM
Bravo

Thanks for the Perfect Solution

:clap::clap::clap::clap::clap: