Charting data across time

[jcalvacca]

Hello all,

I have attached a file for reference......

Chart needs to have date on the left and a value on the right....
Will have "blank space" in between entries as shown......

Only values on the x axis will be the dates in the column, no blanks in between and no space, looks like here the chart is "filling in" the dates in between the plotted spots.

Thanks for the help!!

 

[vletm]

@jcalvacca
If left side needs to be date and right side needs to be a value ...
It'll be challenge to get dates ... to x-axis ... and so on ...
This would need to get better visual vision if not enough close to Your vision

 

[jcalvacca]

@vletm

Thanks for the reply

It doesn't need to be laid out that way for data, I can lay it out anyway it needs to be as it will be imported from different part of the spreadsheet.

I believe they will want the x axis to be the "date" analyzed and then the 3 dots stacked up on that date (from Y scale) based on the sketch I'm looking at.

I think main thing is that if there are 4 "dates" than should be only 4 tick marks on x axis.

 

[vletm]

@jcalvacca
You wanted dates to left-y-axis ...
if no need then dates could be in x-axis and then there could be 4 tick marks on x-axis.

 

[jcalvacca]

@jcalvacca
You wanted dates to left-y-axis ...
if no need then dates could be in x-axis and then there could be 4 tick marks on x-axis.

@vletm

See attached picture of vision.....
One series is fine.....
Data will most likely have blank lines in between like in example....

 

[vletm]

@jcalvacca
something like this...

 

[jcalvacca]

@vletm

Close.....

One step further.....
"Vendor" in a different color on top of the existing data....

 

[vletm]

@jcalvacca
It would be much easier to get the vision at once ...
one step ahead two steps backward!

 

[jcalvacca]

@vletm

Thank you!!

 

[jcalvacca]

@vletm

How did you handle the blank spaces in the data not to chart....I understand all the rest of the logic with having the two series but I'm struggling having the chart skip over the " " cells.....thanks.

 

[vletm]

@jcalvacca
the 'blank' spaces ... hmm ... there were no data, so no action!
'blank' is not same than " " that is 'space' ... 'blank' is nothing!

 

[jcalvacca]

@jcalvacca
the 'blank' spaces ... hmm ... there were no data, so no action!
'blank' is not same than " " that is 'space' ... 'blank' is nothing!

@vletm

Correct! Ok, how do I deal with 'space' in between, or perhaps I need to do one more =Value() than to turn the 'space' into 'blank'......

 

[vletm]

@jcalvacca
from 'space' to 'blank' with 'Del'-button.
Are You writing again like 'one sentence from a book'?

 

[jcalvacca]

@jcalvacca
from 'space' to 'blank' with 'Del'-button.
Are You writing again like 'one sentence from a book'?

@vletm

I'm sure I am.....

See attached, I got it to this point.....

Complete data to be charted is in A:C, out to row 424 (needs to be able to go that long)...

Filtered out as previous examples to F:I and K:N respectively......
Have the chart look like the ones you made last week

Thanks again for the help the last week!

 

[p45cal]

I can't close up the dates because it's an XY plot and as soon as I make it a non XY plot it puts values which are on the same date into different x categories.

 

[vletm]

@jcalvacca
S.d to know what have You learnt.
Space <> Blank
full of same formulas
copy - paste
I try to be positive...
Press [Active]-button after You have updated data to columns from A to C