Allow countif (and countifs) to count cells where I am searching an array for a string value. For example, if I have a table with dates in one column and names in another column, but I may have multiple names in a single cell, I want to be able to count the number of cells that have John listed even if that cell also has Jane as a value.

Handy if you have a column of hostnames or IP addresses.

Pls add support for bullet charts

It would be handy to be able to lock the aspect ratio of a chart. I specifically use scatterplots to display a visualization of land surveying points as a check that data entry was correct. Because UTM coordinates are so large and the extent of the survey points changes with every entry the chart continually resizes.

Extend the ability already in Power View and 3D Map/Power Map to 'play' all charts using a time/date field. The Timeiline Slcer looks as though it could be an ideal way of doing this - just by adding the ability to play through the selected time increments in the Slicer.

Instead of fixed legends, please allow the user to create a dynamic legend, so that if there are no values for a particular category, the legend does not show up for that category.

Find and replace should work with charts too, both with text shapes and with the series' formulas. This is a major time saver for editing many series' at once.

Jon Peltier made an addin that implements this: http://peltiertech.com/change-series-formula-improved-routines/.

Could you make the MODE function work for text?
Currently you have to do a crazy index and lookup thing, which could all be made so much easier if mode worked for text. i.e., if you have MODE("a", "b", "c", "a") you would get "a".

Add a 'series description' option when creating a series. Then when adding the legend you can select to use the series name or series description as the legend. Would be useful when using data labels that need the series name shortening in some graphs - the legend then acts as a key

It is not possible to access a point's values or range from VBA. We have to parse the point's name (S3P14), the go to the third series' 14th cell in the x values range to access the points' value or range.

It is also not possible to access a series' legend entry as a property from VBA.

There are many examples of this kind of "incompleteness" of the VBA charting object model. It would be great if these related objects could be exposed, to simplify code.

It appears when the range of data in a chart is huge, providing a scrollbar can be a handy option to scroll through big data in a user friendly way (without going through sizing -resizing again). If you can provide this option with charts (and thus in VBAs), it will be a handy feature to work with !
Cheers, Pramod

In corporate world generally powerpoint presentations are used because they give option of animations.

in excel it is possible to do with VBA (to some extent) but still its very hard.

If it could be made possible to give animations in Charts/ areas (A1:G7) / Name ranges, it would be very useful for presenting data.

thanks for the forum. its really great. :)

Regards
Sarvesh Prasad

Please provide a way to add labels automatically to scatterplots. It would be great if you could add a third dimension of data that would be text labels for scatterplots.

Least squares fitting only minimizes the error in dependent variables. The error in the independent variables is ignored.

For the graphing of any data obtained by measurement, such as in science, we should consider the error in all variables, and so we should have an option to plot curves of best fit based on total least squares fitting.

It would also be nice to have an option to specify Deming regression in some of the line-of-best-fit-related functions such as SLOPE, INTERCEPT, FORECAST, LINEST, TREND, PEARSON, and RSQ.

1) Allow multiple data labels/ bars to be selected simultaneously for editing/formatting or movement
2) Allow a specific data point/ bar of a chart to be used for individual hyperlinking

I would like to have custom tool tips for a chart. I have hidden the x axis labels and added some data labels and would like the tool top to display the data label text instead of the x axis label text. I have exported the chart from a vb.net winform app but have been told that this currently isn't possible and advised to post on here!

Since graphs series cannot contain formulas, if you want to make a graph dynamic, you must use a name (in the Name Manager sense) that contains a formula that determines the dynamic range.

However, if that name uses structured references, then when you save and reopen the file, Excel will crash and the workbook will be unusable to Excel.

To see what I mean, download this workbook:
http://www.mediafire.com/view/a2681miflhdjxep/Graph_Crash.xlsb
Right-click on the graph and go Select Data. Edit Series1 and change its series values to read "=s!y" (without quotes). Save, close, reopen, crash.