Line graph - help!

**fudgee0** · 04-21-2013, 12:44 AM

Hi everyone!

Okay, I'm relatively new at excel so I'm a bit of a major noob at it. This might seem like a really silly question but after trying everything I still haven't been successful with plotting this graph. I'm trying to plot a line graph showing two graphs (systolic and diastolic blood pressure) with BMI on the x axis. However, every time I try to plot the BMI values on the x axis, it doesn't show the full range of values and stops at around 29 when the data goes up to somewhere around 60.
Data Females.xlsx

I've attached the data I'm trying to graph so if anyone would be able to help out that would be fantastic! Thanks!

**dilipandey** · 04-21-2013, 04:16 AM

Hi fudgee0,

welcome to the forum.
See the attached file where I used a pivot chart... thanks.

Data Females.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**fudgee0** · 04-21-2013, 10:04 AM

Hi DILIPandey!
Thanks so much for replying

I'm just not sure what you mean by "Sum of SysBP". What do these values indicate?

**dilipandey** · 04-21-2013, 02:30 PM

It is the way pivot table displays the heading.. here it is summing sysBP against BMI (x - axis). thanks.

Regards,
DILIPandey
<click on below * if this helps>