Questions tagged [charts]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Can't edit horizontal (catgegory) axis labels in excel

The horizontal (category) axis labels editor aren't clickable on my excel scatterplot. How can I fix this?
0
votes
0answers
15 views

Add multiple Utilization (percentage) trend lines to a Stacked Bar Chart with a count

I would like to know how to put in percentage trend lines for individual levels in a stacked bar chart using the data below. I want a usage trend line for the total, as well as certain specific levels....
2
votes
0answers
24 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
1answer
34 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
1answer
35 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
1answer
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
1answer
25 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
1answer
39 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
1answer
118 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
1answer
57 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
0answers
34 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
1answer
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
0answers
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
1answer
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 ...
1
vote
1answer
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
0answers
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
1answer
39 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
1answer
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
1answer
32 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
0answers
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
1answer
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
0answers
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
0answers
15 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
0answers
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
1answer
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
1answer
71 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
0answers
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
2answers
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
1answer
35 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
1answer
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
1answer
26 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
2answers
123 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
2answers
35 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
1answer
40 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
0answers
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
0answers
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
1answer
161 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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
95 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
1answer
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
0answers
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
1answer
66 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
1answer
78 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
1answer
91 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 ...