ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart making (https://www.excelbanter.com/charts-charting-excel/25830-chart-making.html)

Arun Bhadoria

Chart making
 
When I select a column of data to make a chart. It only takes first cell and
leave all others. In chart shows only one value, why?

John Mansfield

Arun,

Please try this first - if you are working with the Chart Wizard, make sure
that you have the option "Series in Columns" selected as opposed to "Series
in Rows". This input is available in step number 2 of the wizard under the
Data Range tab. If this doesn't work can you post back with a sample of your
data?

--
Regards,
John Mansfield
http://www.pdbook.com


"Arun Bhadoria" wrote:

When I select a column of data to make a chart. It only takes first cell and
leave all others. In chart shows only one value, why?



All times are GMT +1. The time now is 01:13 AM.

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