ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can't get chart from SQL Data (https://www.excelbanter.com/charts-charting-excel/213034-cant-get-chart-sql-data.html)

Alixukl

Can't get chart from SQL Data
 
Hello Friends,

Please help to solve this problem:
I run SQL query, received the output, saved them in Excel and tried to plot
a chart but no success.
Actually I only can plot the chart after I re-write all data in equation
type, I can't get chart from original Excel data which contain decimals.

BRs,

A

cesar

Can't get chart from SQL Data
 
I've been doing the same as you, getting data from SQL data base using a
Query, I define the cell where I want the results be posted, lets say
starting in column J through K, including the columns headers. Then I build
the Chart for the data in column J, lets say a Line Chart, and what I do is
selecting the Whole column (J:J) and just follow the chart wizard. In that
way, the data shown in your chart will grow or shrink according to your data
being pulled from the SQL database.
Hope that help
--
Cesar


"Alixukl" wrote:

Hello Friends,

Please help to solve this problem:
I run SQL query, received the output, saved them in Excel and tried to plot
a chart but no success.
Actually I only can plot the chart after I re-write all data in equation
type, I can't get chart from original Excel data which contain decimals.

BRs,

A



All times are GMT +1. The time now is 11:03 AM.

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