How can I convert X-axis in stack bar chart from Date to Custom Workweek format

[vhar]

Hi,

Is there a way we can convert the date format to Work Week format in the Stackbar chart? Attached is the sample sheet with it's axis to Date. But I want to change that to Work Week format as put in the Column-I.

Thanks for your help....

 

[NARAYANK991]

Hi ,

Is this acceptable ?

Narayan

 

[vhar]

Hi Narayan,
Wonderful and it is exactly what I expected. But can you also brief me how did you add the made the custom number format for this ?

Thanks again...

 

[NARAYANK991]

Hi ,

You can see that a Dummy series has been added on the secondary axis ; a secondary horizontal axis has been used , and the primary horizontal axis has been used without any axis labels.

For the secondary horizontal axis the custom format "WW "# has been used.

The Dummy series itself makes use of the week numbers in J3 : J12 , and the series has been formatted with No Fill and No Border.

Narayan

 

[Khalid NGO]

Hi vhar,
Firstly welcome to the forum...

See the attached file if it helps...
Now sure i've fulfil your requirement.

 

[vhar]

Thanks Narayan for your explanation.. Good help from you today..

 

[vhar]

Khalid,

Thanks for your effort.. This also looks ok for me... Narayan solution is more suitable..

thanks for your help also.. It is really very useful forum...

 

[Khalid NGO]

Khalid,

Thanks for your effort.. This also looks ok for me... Narayan solution is more suitable..

thanks for your help also.. It is really very useful forum...

You are welcome...
Thanks for the feedback and welcome back any time with new queries.
Have happy learning here

 

[vhar]

Hi,

I have a following request. Minor lines differentiate a day in the week. But how can I convert this chart to Work week means showing only 5-days instead of 7-days ? Any one have any idea how I can do this ?




Attached is the source file.

 

[Khalid NGO]

Hi,

I have a following request. Minor lines differentiate a day in the week. But how can I convert this chart to Work week means showing only 5-days instead of 7-days ? Any one have any idea how I can do this ?

View attachment 17982


Attached is the source file.

Hi,

Is that you were looking for? :


Regards,

 

[vhar]

Khalid,

No. If you see my plot you have 7-segments in a week denoting 7-days. But I want to reduce that to 5-segments per week.

" I dont want to show saturday and Sunday in work plan ". That is the key

 

[Khalid NGO]

Oh,
I think you should try in D3:

=NETWORKDAYS(B3,C3)
copy down.

is this ?
if not, sorry i didn't understood your question.

 

[vhar]

Hi Khalid,

May be I will add a graph how I want it. Here it is I want my final graph look like.. [ I did manual editing and altered the picture to look like this]

 

[Khalid NGO]

Hi Khalid,

May be I will add a graph how I want it. Here it is I want my final graph look like.. [ I did manual editing and altered the picture to look like this]

View attachment 17990

Hi vhar,
Sorry, I am not getting anything looks like above.
not sure what you are looking is possible or not. hope someone will confirm.

Regards,