ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Lines from chart are not joined (https://www.excelbanter.com/charts-charting-excel/244380-lines-chart-not-joined.html)

MIguel

Lines from chart are not joined
 
Hi,
I have charts where my data are joined by lines, but there are a two points
where the lines are not joined and then the data continue to be joined by
lines. Is there a reason why the two poins are not joining? Is there a way to
fix it?

Thanks
Miguel

Bernard Liengme[_3_]

Lines from chart are not joined
 
Tell us about your data
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Miguel" wrote in message
...
Hi,
I have charts where my data are joined by lines, but there are a two
points
where the lines are not joined and then the data continue to be joined by
lines. Is there a reason why the two poins are not joining? Is there a way
to
fix it?

Thanks
Miguel




MIguel

Lines from chart are not joined
 
Hi,
the data are ratios that fluctuate from 0.80 to 1.20 and the type of graph
is a trend line. On the x-axis I have month and year and on the y-axis I have
the numerical data. The funny thing is that I have the same issue for several
graphs, not only one, and sometimes it's not every single trend line but
sometimes it's only 2 out of 5.

Thanks

"Bernard Liengme" wrote:

Tell us about your data
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Miguel" wrote in message
...
Hi,
I have charts where my data are joined by lines, but there are a two
points
where the lines are not joined and then the data continue to be joined by
lines. Is there a reason why the two poins are not joining? Is there a way
to
fix it?

Thanks
Miguel






All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com