Highlighted
New Contributor

# Creating a simple chart in excel -- why is it so hard?

I want to create a simple chart.

Example -- I want to chart the following data.

I have a service that uses a freemium model.  The first 20 accounts are free, but I will charge \$5 per account for managing 21 or more.  I will cap the amount at 475 accounts which equals \$2375.

The chart should look like this.... (I drew this on PowerPoint)

Here is the data from Excel:

When I chart this here is what I get:

What?!

Then I try and not label the "Accounts" column -- see below:

and that ALMOST looks right BUT not the 0 (zero) values on the X axis.  They are the count of the cells where the data is stored, NOT the values in the "Account" colums!

Really?  Seriously?!

I am tired of feeling like an idiot by myself, thought I would share and see if someone could help me... on what I thought would be a SIMPLE task.

Thanks in advance to anyone who can respond.

4 Replies
Highlighted

# Re: Creating a simple chart in excel -- why is it so hard?

Hello @Roger895,

In the "Accounts" column enter all values 1 thru 5000 with autofill.

In cell C4 enter the formula:

`=IF(\$B4<=20,0,IF(\$B4>=475,\$E\$4*475,\$B4*\$E\$4))`

and copy down using autofill.

Highlighted

# Re: Creating a simple chart in excel -- why is it so hard?

@PReagan -- thanks for the tip.  I put the data together to show the issue with my charting problem -- it was rushed.  Any ideas on the chart?

Highlighted

# Re: Creating a simple chart in excel -- why is it so hard?

It looks like you need to click Edit on right pane and assign Accounts column as horizontal axis, plus remove it from Series.

Highlighted

# Re: Creating a simple chart in excel -- why is it so hard?

As an alternative solution:

Change your chart type to X Y (Scatter) > Scatter with Straight Lines.

Remove the markers by left clicking the line > Series Options > Marker > Marker Options > None