Making a chart with 3 columns for 3 products
I am having some difficulties in making a chart, i have to make a chart to represent 2 data in it : products sold and products prices.
My problem is the way i would like it to look like, i made an image to describe the way i would like it to look like.
I'm trying to make it from X Y (Scatter) type but i can't figure out how to make the X Axis contain product names, and the middle line which delineates the areas.
The data source is a simple table like the one below :
Last edited by maxcong; 04-17-2013 at 04:15 PM.
Re: Making a chart with 3 columns for 3 products
xy-scatter has only numeric axes.
Given your data set you can use Line chart.
If you reall must use a xy-scatter you could either use a dummy series and data labels to build the axis or add a series as column or line.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1