Feedback by UserVoice

Jon Peltier

My feedback

  1. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    I like this idea. Like Felipe, I'm out of votes. Too many good ideas.

  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    Aren't these the minor gridlines? We have them in Excel for Windows; I'm not at my Mac now, so I can't look for them there.

  3. 89 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    While you're at it, why not restore color to the QAT icons.

  4. 72 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    We are looking at several ways to make formatting easier. This is an interesting approach that we will consider.

    Thanks,
    Scott [MSFT]

    An error occurred while saving the comment
    Jon Peltier commented  · 

    In my chart utilities add-in, I have a similar dialog that shows all series, with fields showing series name, ranges containing name and X and Y values, series chart type, axis group, etc. The purpose of this dialog is to allow changing source data of multiple series in one go.

    Doing the same for formatting would be as valuable. I have not yet attempted it, as adding the formatting UI is a bigger deal than the simple text-based UI needed to modify ranges.

    Jon Peltier supported this idea  · 
  5. 79 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion, and thanks for showing how you’re using the FORECAST as a workaround. We’ll consider this request along with all the other ideas here and prioritize it according to the votes – so please keep voting if you want to see the priority raised!

    Best,
    John [MS XL]

    Jon Peltier supported this idea  · 
  6. 1,074 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Jon Peltier supported this idea  · 
  7. 208 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the post Charles! And thanx to folks for voting. Much appreciated. We definitely understand the ask and are keeping a close eye on this as it is moving up the vote charts .

    As always, please keep upvoting the things you are about most.

    Thanx,
    Prash [MS XL]

    Jon Peltier supported this idea  · 
  8. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    Andi -

    What hassle? Just click in the data range and press Ctrl+T. No more worries.

  9. 811 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    An error occurred while saving the comment
    Jon Peltier commented  · 

    More information...

    Thank you for responding to my suggestion. I've been making it for over a decade, and I understand it's not a big screaming bug, but it does cause problems for users.

    What a good NULL() function would do is have its parent cell behave as a blank cell, despite containing a formula.

    In a chart, a NULL() value in a cell would suppress drawing a data point and its associated label in any type of chart, and a gap would connect the points on either side in a chart type that used lines and markers.

    A blank cell meets these criteria. There is no marker in a line chart, and there is a gap in the line; also there is no data label in the column chart. The line chart with #N/A has no marker, but the line connects the points across #N/A, and the column chart has a label that says "#N/A".

    For formulas, I would have almost every other formula treat the cell returning NULL() as a blank cell. If A1 returned NULL(), then ISBLANK(A1) would be TRUE, ISNUMBER(A1) and ISTEXT(A1) would both be FALSE. COUNT(A1) and COUNTA(A1) would both be 0, and COUNTBLANK(A1) would be 1. Any numerical or statistical calculations involving the cell contining A1 would treat it as it would have treated a blank cell.

    In the only deviation I can think of from an actual blank cell, I would make ISFORMULA(A1) be TRUE.

    Some workarounds to a good NULL() formula and their consequences are:

    (1) NA()
    chart: omits marker (good) but does not leave gap in line (bad)
    formula: further calculations affected by error (bad)
    appearance: #N/A is ugly in a cell (bad)

    (2) ""
    chart: plotted as zero (bad), also data label shows "0" (also bad)
    formula: may produce unexpected results (bad)
    appearance: looks blank in a cell (good)

    (3) VBA to clear contents of cell
    chart, formula, appearance: just like a blank, because it is (good)
    have to rebuild any deleted formulas if precedents change (bad)

    (4) VBA to step through a chart and format a point to be invisible (e.g. a bar or column, a marker and line, data labels), but the chart would have to be restored if data changes.

    (5) There are complicated ways to structure a chart's source data that produce gaps where NA() would appear, and I've blogged about a few, but these are tedious, fragile, manual workarounds.

    You can search the web and find many people hunting for something like this NULL() function:

    http://stackoverflow.com/questions/1119614/return-empty-cell-from-formula-in-excel
    http://stackoverflow.com/questions/18768020/if-statement-how-to-leave-cell-blank-if-condition-is-false-does-not-work
    http://www.exceltip.com/excel-text-formulas/adjusting-a-formula-to-return-a-blank-rather-than-a-zero-when-operating-on-empty-cells.html
    http://superuser.com/questions/837038/excel-how-to-create-truly-blank-cells-from-formula-so-that-they-wont-show-up
    http://excel.tips.net/T002814_Returning_a_Blank_Value.html
    http://www.exceldashboardtemplates.com/how-to-show-gaps-in-a-line-chart-when-using-the-excel-na-function/
    http://www.mrexcel.com/forum/excel-questions/686864-how-create-gap-line-chart-empty-data-when-data-series-populated-array.html
    http://stackoverflow.com/questions/17792863/graphing-blank-cells-in-form-of-gaps-in-excel

    Here are a few articles in my blog:
    http://peltiertech.com/mind-the-gap-charting-empty-cells/
    http://peltiertech.com/vba-approaches-plotting-gaps-excel-charts/
    http://peltiertech.com/another-approach-plotting-gaps-excel-charts/

    There is a lot of confusion and a good many workarounds, but nothing that feels right.

    An error occurred while saving the comment
    Jon Peltier commented  · 

    Anonymous - NA() is not a complete solution. It stops plotting of a marker, but if the series has connecting lines, they connect the points on either side of the NA(). Also, NA() suppresses plotting of points for line and scatter charts, but not for column charts and other types.

    Jon Peltier shared this idea  · 
  10. 71 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    Charts do not plot true nulls, that is, blank cells. Bet there is no way to make a formula return a null value, only something that looks blank, like "".

    Go vote for "Give us a proper NULL() worksheet function."
    http://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9095062-give-us-a-proper-null-worksheet-function

  11. 337 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Jon Peltier supported this idea  · 
  12. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Jon Peltier commented  · 

    What Tom said.

  13. 1,170 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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]

    Jon Peltier supported this idea  · 
1 2 4 Next →

Feedback and Knowledge Base