Unable to get properr graph

Hello,

i have some data in excel which i need to show in graph using UiPath.
I am not getting proper graph.
data is like below


i am getting grpah like below

i need like below.

we we do manually in excel we click on recommended and show data .
can we show in above format?
please help me on same.

Hi @Mathkar_kunal

Check out this thread once:

1 Like

i can save chart in output but how to represent that, it is saving in boolean.
please help
giving error also
Bar Chart: Object reference not set to an instance of an object.

Hi @Mathkar_kunal

Prepare the data for the graph by using Sort datatable activity.
Use the Insert chart activity to insert the chart in the excel sheet.
Find the below link to know more about the Insert chart
https://docs.uipath.com/activities/other/latest/productivity/insert-sheet-x
image

Hope it helps!!

tryied but getting data in same fasion



is anything i am missing in properties or something or is anything wrong?

Hi @Mathkar_kunal

You don’t need output. It will be considered for further process if required.
Try like this:


image

It will automatically create the bar chart in the sheet name you have mentioned in the properties.

getting this error
Bar Chart: Object reference not set to an instance of an object.

@Mathkar_kunal

Check your cell range. Give the data range correctly.
You are give one column there, so the error occurs.

where i have provided column?
please highlight

@Mathkar_kunal

Give like this
Cell range:“A1: B1000”

“A1:A1000” means you have given input only A col with 1000 rows.

same error object reference

@Mathkar_kunal

Check the input range which required for bar chart. And check the sheet name once.

Share the properties and error details.


data look like this only in a column.

@Mathkar_kunal

You need to have another column that containing the number of cities present. Like
Banglore - 20
Mumbai - 30
Hyd - 20

Like that.
Graphical representation refers to the use of charts and graphs to visually display, analyze, clarify, and interpret the data. So they didn’t perform any operations like addition and subtraction.