Data selection in Chart

[Prashantvk123]

Hi all

I am facing a problem in preparing chart, my data range in the chart is not picking up correct value. please have a look at the attachd file.

 

[Somendra Misra]

Hi Prashant,

Nothing is clear from the image you uploaded, its not even clear. Kindly, upload a sample file, so that somebody can see what's going wrong. From the image its hard to tell why it is not selecting proper data.

Regards,

 

[Prashantvk123]

Hi Somendra, I have uploaded the file.

if you can see i have four column Name of the processor, Time, Targer time and utilization.

in the graph I want to prepare the bar graph having different bars for Time, Target and Utilization but when I select the data and try to prepare the Bar chart the bar is showing only for Utilization.

 

[Somendra Misra]

@Prashantvk123

See the file.

Regards,

 

[Prashantvk123]

Hi Somendra,

Thanks a lot,, could you please advice excatly why it was happening.

 

[Somendra Misra]

Well I actually don't know the exact reason behind it, but it is treating first 3 columns as X values. If you delete Processor i.e. B3 and select data , you will get it.

Regards,