Trend Graph from values on a single raw

Hi all,

I cannot create a trend graph from values displayed on a single raw. For instance let's consider the below chart. I would like to create a graph showing the trend of kpi's (column 2) from Jan to March for 2 persons: John and Bob. Attached a screenshot that maybe can helps.

Thanks in advance. Regards,

People Food (KPI's) January February March
John Bread units 10 20 40
John Bread % sold 20% 50% 10%
John Eggs units 50 100 20
John Eggs % sold 50% 10% 4%
Bob Bread units 70 30 10
Bob Bread % sold 7% 1% 2%
Bob Eggs units 40 20 100
Bob Eggs % sold 10% 100% 20%

Originally Posted by TRS

Hi all,

I cannot create a trend graph from values displayed on a single raw.

Hi there - I have no idea what the sentence above means. So I have used a bit of imagination.. see the attached for a line graph for "units sold" by bob and john for both eggs and bread. Personally, I would have a separate gragh for each product or it could get messy! If you wanted to included % of product sold it would get messier still and loose meaning so consider a separate graph for this. You may also want to concider a pivot chart.