# Questions tagged [charts]

Graphs, charts and other graphical methods for showing data and their relationships.

1,252
questions

**2**

votes

**0**answers

23 views

### Saving Charts with Multiple Series in Excel and PowerPoint

Context
I'm trying to create a multi-series chart/infograph to display total number of sales for the day as compared to the average. The chart consists of three series:
Series 1: The base bar graph ...

**0**

votes

**1**answer

33 views

### Plot two date series as a column chart

I am trying to plot multiple series of (year, value) points in Excel, but I would like to display them as a column chart. I begin by plotting the data as two series in an x,y scatter plot which works ...

**0**

votes

**1**answer

34 views

### Excel add weekly total and daily totals on same graph

I have a finance sheet that tracks all of my expenditures and totals over time. It has a dashboard with a graph that shows the running total on a weekly basis. I also have one that is the running ...

**0**

votes

**1**answer

12 views

### Excel generating wrong scale for graph, plotted points disappear when corrected

I'm trying to generate a graph using the values listed in the data tables above the graph; when first generated the scale of the x-axis is wrong and when corrected, the plotted points disappear. How ...

**0**

votes

**1**answer

24 views

### How to reverse Excel legend order?

I have an Excel graph (a stacked bar chart) where years are on the x-axis.
The problem is that the order of the legend labels doesn't fit with the order of the values in the bars as shown in the ...

**2**

votes

**1**answer

38 views

### Excel - Line Graph a specific day of the week

I have a daily sales spreadsheet for the entire year - Weekday, Date, Orders, Guest, Sales in Columns (365 rows - one for each day). (There is more data to this table, and it is formatted and imported ...

**0**

votes

**1**answer

114 views

### Combining a clustered column chart with multiple line markers plots in Excel 2010

Is it possible to combine a clustered column chart with multiple (line) markers plots, so that each markers plot is 'aligned' with one series from the clustered column chart (in Excel 2010)?
Just to ...

**0**

votes

**0**answers

43 views

+50

### Uneditable Transformed Row Source for MS Access Chart Keeps Resetting Sort Order

Inserting a bar chart object into a Microsoft Access form brings the data into view with a sort order I did not preset when I first designed the underlying query.
I can see that the unwanted sort ...

**0**

votes

**0**answers

33 views

### Create a graph to show the relative frequency of each word?

y, I would like to create a graph which shows the relative frequency of each word.
For example I have one column which contains different words which are also separated by a semicolon sometimes.
My ...

**1**

vote

**1**answer

49 views

### MS Excel Plots not displaying correctly

This was originally asked here but has been voted for closure and moved to this site.
I have a dataset in excel like the following (starting at cell A1 going to D100)
| Part | MK_CREATED_DT | ...

**0**

votes

**0**answers

16 views

### MS Excel Plots not displaying correctly

I have a dataset in excel like the following (starting at cell A1 going to D100)
| Part | MK_CREATED_DT | ORD_NUM | LINE_NUM |
|:------:|:---------------:|:-------:|:--------:|
| DEW361 | 10/17/...

**1**

vote

**1**answer

36 views

### Label Position Appears to have gone AWOL

Hi, Does anyone know if Label Position has been removed from Excel 2019? Just changed over to 2019 and "Label Position" appears to be missing from Format Data Label options. Thanks in advance for your ...

**0**

votes

**1**answer

54 views

### stacked trend line in Excel 365 with series name in a column [closed]

This is the format of my file:
|Series| Date (X axis) | Data (Y axis) |
| A | 05-May-16 | 32 |
| A | 16-May-16 | 28 |
| B | 17-Mar-16 ...

**1**

vote

**1**answer

26 views

### How to generate Excel Chart with this grouping

Assume the following data on a sheet:
date source type hits
2019/08/01 Source A 1 3
2019/08/01 Source B 1 2
2019/08/01 Source A 2 19
2019/08/01 Source D 2 10
...

**2**

votes

**0**answers

27 views

### Excel Line chart X-axis does not display the right date/time

I am trying to plot a line chart in Excel , the x-axis is changing the year value significantly and I cannot figure out why.
It is taking my data from 2017 and adding over 100 years to it. For the ...

**0**

votes

**1**answer

37 views

### How to plot a graph showing a score for each line in Excel?

How to plot this kind of graph ?
(Here is the source)
Considering that I have this :
Option A:
Person I : 0
Person J : 2
Person K : 4
The score goes from 0 to 5.

**0**

votes

**1**answer

25 views

### How to show specific values in x-axis of an Excel scatterplot

How can I change the x-axis in Excel, so it only shows specific values.
I would like the x-axis only to show the values of the corresponding x-value of my data.
I have a image of how I would like ...

**0**

votes

**1**answer

31 views

### Excel Scatter Chart

I am try to create a chart that shows the difference in pay between male and female. I want pay at the top/bottom, sector on the left, and a male/female icon and the pay points. I can not seem to ...

**0**

votes

**0**answers

21 views

### Varying Chart Range Based on Drop Down Lists

I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list.
I have 3 selections for my drop down list: All, Alberta and Saskatchewan....

**0**

votes

**1**answer

57 views

### Excel Chart with Different Series Lengths

I run a pool league and I have a chart of player handicaps over time. Handicaps change over time based on performance. Since not all matches are played on the same days, I chart against the ordinal ...

**0**

votes

**0**answers

13 views

### How can I set up a bar chart to have two bars for each product on different axes that don't overlap?

I am trying to put together a Pivot chart and would like to have two values associated with each of our products, each displayed on a separate bar. One of these bars is Sales (Tonnes), and the other ...

**0**

votes

**0**answers

12 views

### How format horizontal axis as a date on the Gant chart in the Google Spreadsheet?

This is my template for the Gant chart that I modified from other chart somewhere from the Internet.
How to format the horizontal axis as a date but not some number like it is now?
I want to see ...

**0**

votes

**0**answers

23 views

### VBA conditional line formatting

I have a chart with many series. There is a Series Collection titled ("Upper Limit"). If any other series in the chart crosses over that threshold, it needs to be changed to a dotted line. I get a run ...

**0**

votes

**1**answer

27 views

### Three dimensional named ranges for dynamic graph

I have a table which contains values of 10 variables for every day in a calendar year. See attachment for reference.
I'm trying to create a line chart with the following options:
Select any of the 5 ...

**0**

votes

**1**answer

65 views

### Filtering data for graph in Excel

I have a x and y set of data I am trying to filter for a graph. The problem with my data is there are too many points, and I would like to filter out a significant amount of the data. In my case, I ...

**0**

votes

**0**answers

25 views

### Chart Data Based On Cell Value

Project Task Chart
Hi, I'm trying to chart the progress of project tasks dependent on the status of the project. I have a table with all projects and the % progress and % remaining for all tasks ...

**2**

votes

**2**answers

64 views

### Switching X and Y values for every series in scatter chart

Oy people! My problem is as follows:
My data table:
Selecting the data and creating a scatter chart nets me such a result:
Then for each series I have go and manually edit them, switching X and Y ...

**0**

votes

**1**answer

34 views

### Keep the error bars in foreground in Excel scatter chart

Often in my work I place vertical scatter data inside a graph and overlay a single data point corresponding to the average of that group of data. When I place error bars on that average, the error ...

**1**

vote

**1**answer

19 views

### Excel: when combining column chart and line chart, position of the line

I am trying to obtain the following chart: for each month, a column chart representing the amount of money spent, and line chart representing the amount of money I had at the beginning of the month.
...

**0**

votes

**1**answer

23 views

### Add a second horizontal axis with different values in an Excel combo chart?

I have a combo chart (clustered column and line). They are currently using the same x-axis (which is simply the number of weeks, starting at 1) and different y-axes (primary one for the stacked column,...

**1**

vote

**2**answers

117 views

### Create an exploding stacked column chart

I want to create an exploding stacked column chart similar to this:
For example, I want to create the graph from the following data:
+--------------------------------+--------+--------+
| Process ...

**0**

votes

**2**answers

33 views

### How do I lock the Plot Area's size so it doesn't resize when I resize the Chart Area? (Excel/Office 365)

I have two pie charts side by side and I want them to be the same size.
However, in pie chart #2, I need to move the Data Labels away from the pie chart which means resizing the Chart Area.
The ...

**1**

vote

**1**answer

39 views

### Excel Chart Color - Create charts with conditional formatting on “text value”

I have a data set of Companies/Products with their performances for every quarter.
I am creating a lot of graph to display the various performance.
Problem:
In order to be coherent, I'd like
to ...

**1**

vote

**0**answers

35 views

### How to create a 3D plot with orthographic projections – Matlab

How can I generate a 3D plot with the orthographic projections of a parametric curve on the inside walls of the 3D plot, as shown in this youtube video?
I can generate a 3D plot of the curve using ...

**0**

votes

**0**answers

40 views

### Excel male and female filled chart

I was creating a male and female chart, target to 100%, but the chart keeps breaking when both the filled values are 90%. Although I was doing it slightly different this video shows what I was trying ...

**1**

vote

**1**answer

159 views

### MS Excel - How to model my data in order to produce a chart broken down into product and month (year on year)?

I have one single date column in my raw data. The dates range across 2018 and 2018. I have multiple products and each row represents a sale transaction. There are multiple transactions per product.
...

**0**

votes

**1**answer

29 views

### How manually enter data in excel plots?

I want to enter raw data into excel plots just by typing the numbers 20.35,20.35 but excel doesn't allow this by default and only accepts data from cell references. How to do it my way?

**0**

votes

**0**answers

28 views

### Replace numeric scale with text

I have a scatter chart where the scales are numeric.
Is there a way to replace the vertical or horizontal scales, which are by default numerical with specific texts per value?

**1**

vote

**1**answer

16 views

### How to alter axis points on a simple stacked bar chart in Excel

Using Office 365, I created the second type of stacked bar chart using the following data:
10.3
4.133333
0.25
9.316667
The axis marks are automatically set from 0 to 30.
On changing the maximum ...

**0**

votes

**0**answers

14 views

### Import graph from elsewhere into excel so that it is still editable

http://www.lock5stat.com/StatKey/descriptive_1_cat/descriptive_1_cat.html
I want to be able to import some graph from another website into excel and have it still editable.
Is it possible to do ...

**1**

vote

**1**answer

50 views

### MS Excel - How to add percentage increase to the forecast chart and/or pivot table?

I've managed to successfully create a Forecast line chart. It has produced a table including forecast values, which is great. However, I'd really like to know what % increase it's working on? How ...

**0**

votes

**0**answers

14 views

### Rotate an Excel 2016 funnel chart by 90 degrees from vertical flow to horizonal?

I have made a basic funnel chart in Excel 2016, it looks great. However, it would look better if I could have the flow go left to right rather than up to down. (i.e. rotate the whole chart 90 degrees)....

**0**

votes

**0**answers

45 views

### Excel: Move Elements within Chart using Keyboard Arrow-Keys

I'm trying to move elements within a chart (such as text boxes and inserted shapes) by controlled, discrete distances.
I'd like to be able to use the arrow keys like you can in Powerpoint, but this ...

**0**

votes

**2**answers

91 views

### Linear X-axis with non-linear data points in Excel

I am trying to draw a chart in Excel using the following data:
------------
| x | y |
------------
| 1 | 1.5 |
------------
| 2 | 3.0 |
------------
| 4 | 5.9 |
------------
| 8 | 11.0 |
-------...

**2**

votes

**1**answer

28 views

### Excel Chart - X-axis values stopping at a certain point

I really hope someone can help me with this as it's driving me crazy. I have a chart in Excel which is based on a series of dynamic named ranges. When I update the source data, the table extends and ...

**2**

votes

**0**answers

30 views

### Excel chart complex custom number format

I have an excel chart that is controlled using slicers. The numbers in the y axis range include negative numbers, positive numbers upto 100+ million dollars. The axis has been formatted to display ...

**1**

vote

**1**answer

63 views

### Scatter plot chart with positive and negative axis plus label in Excel 2010

I have 3 columns of data, one is the label, the second and third are numeric values with a range from positive to negative numbers.
I couldn't create a scatter plot with a label in each of these ...

**0**

votes

**1**answer

74 views

### VBA - Copy chart from excel to powerpoint without link (embed)

I have a macro that copies all charts from my Excel sheet into a new PowerPoint file.
The problem is that the charts update themselves if I use a filter while the Excel file is open. To prevent it, ...

**0**

votes

**1**answer

86 views

### How do I read data from Microsoft Graph API into PowerBI?

I'm trying to get a list of subscribed users from my tenant using Microsoft Graph API. I've been using the query https://graph.microsoft.com/beta/subscribedSkus which returns the right information on ...

**1**

vote

**1**answer

403 views

### Grouped scatterplot, categorical X-axis in Excel

I am trying to create a grouped scatterplot with categorical X-axis. My data and my current graph attempt:
I'm trying to group all the letters as points with the same x-value, with no letter being ...