Hi
I have a got basic question:
I have got pivot tables and pivot charts in the same sheet. I have copied some of the pivot charts
to another sheet which is a dashboard sheet. so when the data changes , it refresh the pivot charts and
the dashboard charts also refreshed as per new data, so...
Hi
I am excel 2010 user.
I have got master workbook which has all the data in several sheets.
I have set up another analysis workbook which will has 02 sheets , one for data analysis and 2nd one will have dashboard where I will have all the charts on it,
What I am trying to do here is to...
Hi Chihiro
Problem is solved , i used this link as guidance, http://www.arquery.com/Creating a connection using Microsoft Excel 2007, 2010, 2013.pdf
and selected the Microsoft OLE DB provider for visual FoxPro and then it gives me the option to browse and select the dbf file and then establish...
Hi Chihiro
Problem is solved , i used this link as guidance, http://www.arquery.com/Creating%20a%20connection%20using%20Microsoft%20Excel%202007,%202010,%202013.pdf
and selected the Microsoft
Hi Chihiro
I tried to change connection string, it didn't work. I Will install Visual FoxPro OELDB provider.
Strange thing is I opened a new excel file now and try to establish connection with the dbf file and it take me to this screen when I try to add connection, that never happened...
Please advise how to set up this connection string compatible with
excel 2010, I am just stuck and cant fix it and cant create a new connection. how do I modify this string. I tried to remove
"Jet OLEDB:Bypass ChoiceField Validation=False" and it doesn't save and it comes back again, so not...
Hi
I tried to set up new connection but same
Error.
It’s a dbf file with extension dbf , not sure about
Foxpro .
I don’t know what parameters needs to be
Amended in the connection string to establish
This connection again.
Please advise.
TK
Hi Chihiro
I tried this link :
This link suggest to delete these parameter from connections string:
Jet OLEDB:Bypass UserInfo Validation=False;
Jet OLEDB:Limited DB Caching=False;
Jet OLEDB:Bypass ChoiceField Validation=False
I only have the last one which I deleted and then press ok same...
My excel file is linked to dbf file and my pivot table refreshes when the Dfb file is updated.
Now suddenly it stopped refreshing , seems like connection is lost, and error comes, "could not find installable ISAM"
I am using excel 2010.
In the properties under data connection, I checked the...
Hi Nighltytic
Thanks a lot for taking time and to write very good points here, I wish I could apply all the things you highlighted. I am a very basic user of excel and doing these charts for another department to gain some practical experience in data visualisation, so I will try to address...
Hi Vletm
Thanks for your message, my question is my data
Changes all the time, 3 months , 6 months,
9 months and yearly , so that means I have
To group and ungroup rows manually
Evertime it changes.
You also mentioned some settings to be
Changed with charts , I am open to any
Suggestions to...
Hi
Could you please advise how did you group them, and did you apply any formula to group them. Also noticed in the last 02 months of %age line just drops as compared to the dashboard chart, did you notice that as well. please advise
Hi Narayan
I am attaching the file , as you can see in the dashboard I have changed the vertical minor axis details to hide these in wanted labels, but if you look at the individual pivot tables sheets you can see these labels coming up, somehow the chart is picking the null values as zeros, I...
Hi Nightlytic
Thanks for the advice, by changing the axis ,
I have got rid of these labels, really appreciate
It.
Just wondering why these null values still
Picking. 0 values.
Hi
I am having this problem, I have setup this chart for dashboard, initially the data was for 11 months, when the data is changed for 3 months, chart has shown now three months, if you notice on bottom of June bars there are these 0 labels are coming from nowhere, could anyone advise how to...
Hi Hui
This data comes from SAS , I can export this data to dbf file and then make a connection to the excel and insert all pivot and charts from that connected dbf file. So if the data is for 11 months the pivots and charts will be created from this dbf file, next time when this dbf file is...
Hi Vletm,
could you please advise how you hide extra empty rows and update charts..
do I have to do it manually in each pivot table or it can b done through any formulas..
Hi Hui
The main problem is when the 11 month data is replaced by 3 month data then it doesn't adjust the pivot table
According to the rows and cols , slicers are already there in the dashboard, when the data goes from 11 month to
3 months then all the rest of the month and percentage...
Hi
I am attaching my file, dashboard is based on these pivot tables which has 11 month data, if I replace the data say for three months or 6 months , all pivot tables formulas are broken
as additional rows comes with errors and if effects the charts and all dashboard looks meaningless, I have...
Hi
Thanks for your response , segment is like
App type, state , capacity etc.
I am confuded with the dummy series, could
You please advise on that.
All these charts are the requirement at this stage
To capture all the elements in the portfolio.
I will be glad if you can suggest any other...
I am attaching my dashboard , one of the chart I have is portfolio vs segment, segment is what I select from the slicer and the chart shows portfolio and selected segment approval rate on the chart which you can see with green and yellow lines. I am wondering if it is possible when any slicer...