Karen Price
My feedback
-
1,222 votes130 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.
Thank you again, and please keep sharing your thoughts!
Auston [MSFT]An error occurred while saving the comment Karen Price
supported this idea
·
-
4 votes1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →Karen Price
shared this idea
·
-
3,620 votes983 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.
We appreciate all the votes and comments supporting this suggestion.
Thanks – Steve K [Excel]
Karen Price
supported this idea
·
-
39 votes5 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement some of these suggestions.
In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.
Thanks!
Jonathan Kahati
[PM @ Excel]Karen Price
supported this idea
·
An error occurred while saving the comment Karen Price
commented
One more item please ... add the date/timestamp of the last refresh for the data connection. The previous Data Connections window had this right there so you could see it quickly and then hit the Refresh button, all in the same window. The new panel must have a timestamp and a refresh button to improve it's usefulness.
-
158 votes16 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thank you for taking the time to share your request for adding conditional formatting in charts!
While we think this suggestion has merit, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments and will keep this suggestion under consideration for future development.
Thank you again, and please keep sharing your thoughts!
Auston [MSFT]Karen Price
supported this idea
·
An error occurred while saving the comment Karen Price
commented
I create lots of charts of survey data, ie, here is your current patient satisfaction ratings by medical office, so they are percentage scores. We then do a significance test calculation in another column to test the score for each medical office to the regional average. Based on the value of that significance test, I will shade the bar green if the score is significantly higher than average (a ttest value >=1.96), red if the score is significantly lower than average (a ttest value <=-1.96), or the default bar color (usually a light grey) if the ttest value is within that range. Right now I create a chart with a green series, a red series, and a grey series with formulas to populate the scores in the correct series and a 100% overlap. It works, but having some chart functionality to base the bar color off of a formula or off of the value of another series would be helpful.
Regarding VBA ... I've done that and it does work. However, I publish Excel files to SharePoint and expose named ranges on SharePoint pages using the Excel Web Access webpart. SharePoint and Excel Services do not support VBA, and I've been told they likely never will. So, alas, still hoping for a non-vba solution.