Forum Discussion
Excel Chart Error from SQL Pivot Table
Hello, I am pulling SQL values into excel and the values associated with dates and times will not plot. There are roughly 10,000 data points and the 'values' column comes in as 'general' designated ...
Thank you for helping me.
When I move over the value field to "VALUES" and change it to sum all my data points change to 0.0000.
dpvk8 Can you post a small data sample and upload as an Excel file? click the paper clip icon below the reply box.
IngeborgHawighorst I have attached one tab of this worksheet.
dpvk8 In your source data, the values are stored as text. You need to convert them to real numbers. If the data comes from SQL, you may want to ensure the SQL query uses the correct data type.
If the data in SQL cannot be converted to numbers, you can use Power Query instead of a direct SQL query to get the same data and clean it up in the Power Query editor.
- Is there a way to convert it to a number in Excel?