Have line graph not plot entries that repeat

I have a column with entries that make up a line graph. Between some of the entries there might be segments where the value just stays the same for a number of rows - which just result in a flat graph for that segment. What I would like is for those segments not to be plotted in the graph, so that the next point on the graph will be where the entry changes to something different. Any way to achieve this? Thank you!

Short but useless answer -- yes I'm sure there is some way to achieve this. We will probably need to know more about your data, how it is arranged in the spreadsheet, exactly what you are trying to show in the chart, before we can be more specific than that.

If I understand the request, and if you want to retain the original data I'd copy it to another column, then use the Remove Duplicates functionality to remove the repeated values and then plot the reduced set of data.

Just to clarify what I want, below is a snip of what a column might look like, just with many more entries (around one thousand). What I want is for 2900 to only be shown once, and then ignore the three subsequent identical entries. Copying the column and removing the duplicates would work, but the column grows longer every day, so that would require some manual effort each time more values are added to it - which naturally isn't much to root for.

2560
3600
3430
2900
2900
2900
2900
2650
2400
2770

Perhaps this will help.
1. Put the values in a table so that as new values are added the table will expand
2. In an adjacent column place the following: =A2<>A1
3. Populate the column adjacent to that one using: =IFERROR(INDEX([Entry],AGGREGATE(15,6,(ROW([Entry])-ROW(Table1[#Headers]))/([Non Repeating]=TRUE),ROWS(A$1:A1))),NA())
4. Use the values in the last column for the graph.
Let us know if you have any questions.

Originally Posted by Siberian

Just to clarify what I want, below is a snip of what a column might look like, just with many more entries (around one thousand). What I want is for 2900 to only be shown once, and then ignore the three subsequent identical entries. Copying the column and removing the duplicates would work, but the column grows longer every day, so that would require some manual effort each time more values are added to it - which naturally isn't much to root for.

It wouldn't require any manual entry, just use a simle macro. e.g.

Please Login or Register  to view this content.

Just select any cell in the range and run the macro. It assumes there is no adjacent column values hence the .CurrentRegion bit.
If there is an adjacent column for which you want to retain the values then select the whole range and just use

Please Login or Register  to view this content.

The other assumption is that there is no column label above the data. If not change the Header:= to xlYes

Even better, if the column of data is always in the same position but will vay in length, then create a dynamic range name that will always apply to the whole range of cells, and use that range name in the remove duplicates macro. i.e. the Range name, say 'MyRange' would be defined like

Formula:

Please Login or Register  to view this content.

then in the macro

Please Login or Register  to view this content.