Chart - On legend and Display Values

[prabhu]

I transfer, users project staus update from Access tables to Excel on daily basis and make graphs with those datas.
My problem is i want to project the grpahs with weekly intravels on X axis, but my grpahs shows the legends and values for all the days, is there any way to fix this; I want my graph to display the legents and values only for the weekly intravels;

 

[noboffinme]

Hi prabhu

I'm using Office 2003 & I created a chart with just over 2 weeks of data in daily intervals.

I then right clicked on the 'X' axis to open 'Format Axis' & changed the 'Major' & Minor Unit' value to 7 under the 'Scale' tab.

This changed the daily values to weekly intervals.

Could you apply this to your chart so that when your Access data comes over, it has this interval applied?

Hth.