Styjun

Why do Ichisongas hate elephants and hippos?

Will tsunami waves travel forever if there was no land?

Is it possible to Ready a spell to be cast just before the start of your next turn by having the trigger be an ally's attack?

When and why did journal article titles become descriptive, rather than creatively allusive?

Pressure to defend the relevance of one's area of mathematics

How can I place the product on a social media post better?

A non-technological, repeating, visible object in the sky, holding its position in the sky for hours

Does the EU Common Fisheries Policy cover British Overseas Territories?

Feels like I am getting dragged in office politics

Has any spacecraft ever had the ability to directly communicate with civilian air traffic control?

Binary Numbers Magic Trick

Is GOCE a satellite or aircraft?

Can fracking help reduce CO2?

Will a top journal at least read my introduction?

What does "rf" mean in "rfkill"?

Confused by notation of atomic number Z and mass number A on periodic table of elements

Minimum value of 4 digit number divided by sum of its digits

Why does Bran Stark feel that Jon Snow "needs to know" about his lineage?

What is a Recurrent Neural Network?

A question regarding using the definite article

Why is the origin of “threshold” uncertain?

Are Boeing 737-800’s grounded?

Toggle Overlays shortcut?

Why the difference in metal between 銀行 and お金?

how to get rid of duplicate date in excel line chart?

How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?Is it possible to force Excel recognize UTF-8 CSV files automatically?highstock single line chart?Excel line chart doesn't look rightHow to code in Excel VBA for the following purpose?how to draw line chart with date fomat on excel using openpyxl of pythonLine Chart in excel with date timesExcel - Line chart from date and timeHow to show dates in a chart in Excel?excel bubble chart and line chart combined

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I am using excel track my stock PnL. both 3/1 and 3/2 I have 2 trades. in the line chart, I only want to use the last data of the day.

date return
3/1/19 2%
3/1/19 1%
3/2/19 3%
3/2/19 4.5%
3/3/19 6%

this is what I want to show on the line chart. how do I do that?

date return
3/1/19 1%
3/2/19 4.5%
3/3/19 6%

excel linechart

share|improve this question

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

add a comment | 

1

I am using excel track my stock PnL. both 3/1 and 3/2 I have 2 trades. in the line chart, I only want to use the last data of the day.

date return
3/1/19 2%
3/1/19 1%
3/2/19 3%
3/2/19 4.5%
3/3/19 6%

this is what I want to show on the line chart. how do I do that?

date return
3/1/19 1%
3/2/19 4.5%
3/3/19 6%

excel linechart

share|improve this question

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

add a comment | 

I am using excel track my stock PnL. both 3/1 and 3/2 I have 2 trades. in the line chart, I only want to use the last data of the day.

date return
3/1/19 2%
3/1/19 1%
3/2/19 3%
3/2/19 4.5%
3/3/19 6%

this is what I want to show on the line chart. how do I do that?

date return
3/1/19 1%
3/2/19 4.5%
3/3/19 6%

excel linechart

share|improve this question

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

date return
3/1/19 2%
3/1/19 1%
3/2/19 3%
3/2/19 4.5%
3/3/19 6%

date return
3/1/19 1%
3/2/19 4.5%
3/3/19 6%

share|improve this question

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

share|improve this question

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

edited Mar 22 at 19:20

CallumDA

10.9k62242

edited Mar 22 at 19:20

CallumDA

10.9k62242

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

asked Mar 22 at 19:16

qinking126qinking126

4,1221659106

1 Answer
1

active

oldest

votes

2

Since charts ignore #N/A errors, you can just add another column which produces a #N/A if that date already exists and point your chart to that column instead.

The simple formula, for ordered data, would be something like this

=IF(A2=A3,NA(),B2)

If your data isn't ordered by date then you can use this formula

=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$6,A2),B2,NA())

This is the setup I was using:

share|improve this answer

edited Mar 23 at 16:19

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank you. but I need data from the last trade of the day. for example, 3/1 I have 2 trades, first one I made 2%, second one it dropped back to 1%. I wan to get 1% for 3/1.
  
  – qinking126
  Mar 23 at 16:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, that's easily remedied, I'll update the answer
  
  – CallumDA
  Mar 23 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, see amended formulas :)
  
  – CallumDA
  Mar 23 at 16:19
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55306433%2fhow-to-get-rid-of-duplicate-date-in-excel-line-chart%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

Since charts ignore #N/A errors, you can just add another column which produces a #N/A if that date already exists and point your chart to that column instead.

The simple formula, for ordered data, would be something like this

=IF(A2=A3,NA(),B2)

If your data isn't ordered by date then you can use this formula

=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$6,A2),B2,NA())

This is the setup I was using:

share|improve this answer

edited Mar 23 at 16:19

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank you. but I need data from the last trade of the day. for example, 3/1 I have 2 trades, first one I made 2%, second one it dropped back to 1%. I wan to get 1% for 3/1.
  
  – qinking126
  Mar 23 at 16:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, that's easily remedied, I'll update the answer
  
  – CallumDA
  Mar 23 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, see amended formulas :)
  
  – CallumDA
  Mar 23 at 16:19
  

  
  
  
  

add a comment | 

2

Since charts ignore #N/A errors, you can just add another column which produces a #N/A if that date already exists and point your chart to that column instead.

The simple formula, for ordered data, would be something like this

=IF(A2=A3,NA(),B2)

If your data isn't ordered by date then you can use this formula

=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$6,A2),B2,NA())

This is the setup I was using:

share|improve this answer

edited Mar 23 at 16:19

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank you. but I need data from the last trade of the day. for example, 3/1 I have 2 trades, first one I made 2%, second one it dropped back to 1%. I wan to get 1% for 3/1.
  
  – qinking126
  Mar 23 at 16:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, that's easily remedied, I'll update the answer
  
  – CallumDA
  Mar 23 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @qinking126, see amended formulas :)
  
  – CallumDA
  Mar 23 at 16:19
  

  
  
  
  

add a comment | 

Since charts ignore #N/A errors, you can just add another column which produces a #N/A if that date already exists and point your chart to that column instead.

The simple formula, for ordered data, would be something like this

=IF(A2=A3,NA(),B2)

If your data isn't ordered by date then you can use this formula

=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$6,A2),B2,NA())

This is the setup I was using:

share|improve this answer

edited Mar 23 at 16:19

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

=IF(A2=A3,NA(),B2)

=IF(COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$6,A2),B2,NA())

share|improve this answer

edited Mar 23 at 16:19

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242

answered Mar 22 at 19:31

CallumDACallumDA

10.9k62242