Hello,
Can any one help me on converting the Scatter plot vs. a parameter in to Box plot vs. a parameter ? Attached is the file. with the details. Highly appreciate your help.
Hi,
Anyone knows why I am getting this error while working on exporting the excel charts to PPT. It worked fine for me for one excel sheet but it is giving this error for other excel sheets at different stages ( after successfully copying some charts to PPT)
Hello everyone,
I found an excellent piece of article in Chadoo's website, about how to export charts into PPT automatically.
http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/
Firstly it worked fine for me.
And I am using it in my projects already.
Here is...
Hi,
It didn't work.
Suppose if I enter some test "xyz" for store number -5, it should repeatedly ask until it gets the number. But with the code above, it wont take the text but i bypasses to the next store-number.
Hi everyone,
I am learning macros through Chandoo's 5-part series. In his part-2 series (http://chandoo.org/wp/2011/08/30/variables-conditions-loops-in-vba/), in the example provided, I tried to make some changes and learn.
1. When it ask for input for the "Sales for the Stoe", it accepts any...
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,
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
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,
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...
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...
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....