ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line Charts have no lines (https://www.excelbanter.com/charts-charting-excel/258455-line-charts-have-no-lines.html)

Chad Cameron[_2_]

Line Charts have no lines
 
Hi All,

I have some data that is entirely formulas.

When I try to chart it (scatter point w/ lines) there are no lines.

If I add some random data that is typed it, it will connect that data with
lines.

Is there a way to have the scatter point chart recognize the formulas as
data? (without copying and pasting values)?

Thanks
chad



Jon Peltier[_2_]

Line Charts have no lines
 
Could you give an example of one of these formulas?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/9/2010 7:31 PM, Chad Cameron wrote:
Hi All,

I have some data that is entirely formulas.

When I try to chart it (scatter point w/ lines) there are no lines.

If I add some random data that is typed it, it will connect that data with
lines.

Is there a way to have the scatter point chart recognize the formulas as
data? (without copying and pasting values)?

Thanks
chad




All times are GMT +1. The time now is 07:39 PM.

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