# U Magnitude Value - SpreadSheetView in Plot Over Line
**URL:** https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339
**Category:** ParaView Support
**Created:** [November 5, 2021, 6:43pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339 "2021-11-05T18:43:50Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 5, 2021, 6:43pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/1 "2021-11-05T18:43:51Z")
Hello,
I am trying to represent U Magnitude data in SpreadSheetView of Plot Over line. Please refer to the image below.
In the graph, U Magnitude is represented. But when I hit the button for SpreadSheetView, only Ux, Uy, Uz values are listed but U Magnitudes are not shown.
When exported to a csv file, the same representations without U Magnitues.
Can I add a column for U Magnitude on SpreadSheetView?
Please help,
Thanks.
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [November 5, 2021, 6:47pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/2 "2021-11-05T18:47:34Z")
Compute it using the calculator
---
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 5, 2021, 6:56pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/3 "2021-11-05T18:56:27Z")
@mwestphal Thanks for your answer.
But if I use the calculator filter, can I change all the Ux, Uy, Uz value to U Magnitude at once? I have total 1000 values of Ux, Uy, Uz in the SpreadSheetView.
Otherwise,
Is there any way to add the column for U Magnitude directly in SpreadSheetView?
Please help. Thanks.
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [November 5, 2021, 6:59pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/4 "2021-11-05T18:59:12Z")
Yes, use the following formula with the calculator filter:
`sqrt(Ux^2 + Uy^2 + Uz^2)`
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [November 5, 2021, 7:00pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/5 "2021-11-05T19:00:42Z")
My mistake, you vector has not been identified as an actual vector, how do you read your data ?
---
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 5, 2021, 7:04pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/6 "2021-11-05T19:04:10Z")
@mwestphal Sorry, I don’t understand what you meant. Can you explain it?
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [November 5, 2021, 7:07pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/7 "2021-11-05T19:07:27Z")
A few questions first.
1. Which version of ParaView are you using ? From Where ?
2. Where is your data coming from ? Which format ?
---
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 5, 2021, 7:15pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/8 "2021-11-05T19:15:58Z")
@mwestphal
1. ParaView 5.6.0 64-bit. From OpenFoam v9
2. The data is from the results of simpleFoam simulation, using OpenFoam v9.
---
### Author:  [@mwestphal](https://discourse.paraview.org/u/mwestphal)
#### Post date: [November 5, 2021, 7:17pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/9 "2021-11-05T19:17:12Z")
Ok got it. Just do not use an old version of ParaView, but the last one from [https://www.paraview.org/download/](https://www.paraview.org/download/). Magnitude should appears.
---
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 5, 2021, 7:19pm UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/10 "2021-11-05T19:19:09Z")
Ok. Let me try it and will let you know if it works.
Thanks @mwestphal
---
### Author:  [@limpideyes](https://discourse.paraview.org/u/limpideyes)
#### Post date: [November 6, 2021, 10:14am UTC](https://discourse.paraview.org/t/u-magnitude-value-spreadsheetview-in-plot-over-line/8339/11 "2021-11-06T10:14:31Z")
@mwestphal
That works!
After using the latest version of ParaView, U Magnitudes are shown up.
Thanks, @mwestphal !!!