Hello,
I am trying to create a line chart with numbers from my product Vs a
competitor. The problem i am having is how can i make a chart that will have
four data points comparing to each other? For example
Product A- 1.5 1.2 1.6 1.8
Product B- 2.0 1.1 1.2 1.3
Product A- 70% 20 % 30% 67%
Product B- 65% 30% 65% 55%

How do i get all of these numbers on one chart? Is a line chart correct. I
want to see these numbers compared??
Thank you so much

Hi,

Since the number don't appear related to the percentages you might plot them
on the same chart but two different axes. If they were related I would think
about a pie chart which would display % and Value at the same time as data
labels. Not being a pie, it might be a column or bar chart. But I'm sure
you will get other feedback.

What you really need to do is to try various chart types and see if they
communicate whatever it is your trying to say. Keep in mind the goal of any
chart - to make the data as clear as possible for the viewer.
--
Thanks,
Shane Devenshire


"Jen Needs Help" wrote:

Hello,
I am trying to create a line chart with numbers from my product Vs a
competitor. The problem i am having is how can i make a chart that will have
four data points comparing to each other? For example
Product A- 1.5 1.2 1.6 1.8
Product B- 2.0 1.1 1.2 1.3
Product A- 70% 20 % 30% 67%
Product B- 65% 30% 65% 55%

How do i get all of these numbers on one chart? Is a line chart correct. I
want to see these numbers compared??
Thank you so much

Hey Shane
How do add another axes I have been trying for the past hour and its not
working.

"ShaneDevenshire" wrote:

Hi,

Since the number don't appear related to the percentages you might plot them
on the same chart but two different axes. If they were related I would think
about a pie chart which would display % and Value at the same time as data
labels. Not being a pie, it might be a column or bar chart. But I'm sure
you will get other feedback.

What you really need to do is to try various chart types and see if they
communicate whatever it is your trying to say. Keep in mind the goal of any
chart - to make the data as clear as possible for the viewer.
--
Thanks,
Shane Devenshire


"Jen Needs Help" wrote:

Hello,
I am trying to create a line chart with numbers from my product Vs a
competitor. The problem i am having is how can i make a chart that will have
four data points comparing to each other? For example
Product A- 1.5 1.2 1.6 1.8
Product B- 2.0 1.1 1.2 1.3
Product A- 70% 20 % 30% 67%
Product B- 65% 30% 65% 55%

How do i get all of these numbers on one chart? Is a line chart correct. I
want to see these numbers compared??
Thank you so much