Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel |